DAX Fridays!
Vložit
- čas přidán 23. 08. 2021
- In today's video I will show you the dax needed to conditional format a line chart in Power BI and by doing that, I will show you the difference between SELECTEDVALUE and VALUES.
My second Channel:
• Charticulator #11: How...
Enjoy!
Here you can download all the pbix files: curbal.com/donwload-center
SUBSCRIBE to learn more about Power and Excel BI!
/ @curbalen
Our PLAYLISTS:
- Join our DAX Fridays! Series: goo.gl/FtUWUX
- Power BI dashboards for beginners: goo.gl/9YzyDP
- Power BI Tips & Tricks: goo.gl/H6kUbP
- Power Bi and Google Analytics: goo.gl/ZNsY8l
☼☼☼☼☼☼☼☼☼☼
POWER BI COURSES:
Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:
curbal.com/courses-overview
☼☼☼☼☼☼☼☼☼☼
ABOUT CURBAL:
Website: www.curbal.com
Contact us: www.curbal.com/contact
▼▼▼▼▼▼▼▼▼▼
If you feel that any of the videos, downloads, blog posts that I have created have been useful to you and you want to help me keep on going, here you can do a small donation to support my work and keep the channel running:
curbal.com/product/sponsor-me
Many thanks in advance!
▲▲▲▲▲▲▲▲▲▲
************
************
QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Linkedin ► goo.gl/3VW6Ky
Twitter ► @curbalen, @ruthpozuelo
Facebook ► goo.gl/bME2sB
#CURBAL #SUBSCRIBE
Really missed these videos Ruth - thank you for an amazing new thing I learned today :)
Wow. I didn't know that VALUES can be used like this. Thanks Ruth 😊
Very good one. Very much helpful practically. Thank you
Pleased to hear 👂
This is brilliant. Thank you.
Thank you :)
Eager to see video tomorrow. Thanks Ruth
:)
You are the greatest
Brilliant! Thank you very much
🥳🥳
I like this VALUES and SELECTEDVALUE and IN combination. Thank you. :-)
Thank you so much 😇
Thank you! 🌺
Thanks lot
I discovered the use of "in values" after some struggle. But it was very efficient and "selected value" is forgotten now. Lol
Thanks for this knowledge share.
Fan of yours.
I find the syntax difficult, but the actual use case is brilliant!
And these tables are not to be linked. That's very important
Correct!
Nice
Thanks for shearing. Do u have a video DAX for beginners? Thanks
Thank You Mam,
I have a question,
do we need to create a seperate tooltip page everytime, if I want to show different data as a tooltip for different columns of single table. Or is there any different way?
cool :)
Thanks for sharing. Can we understand SELECTEDVALUE returns row context, VALUES returns filter context?
Is there any way to bring time on Y axis.. 10am, 11am, 12noon and so on.. I've certain process that finished daily at between 2 PM to 5 pm. Want a graph that shows date on x axis and the process end time on y axis. Unable to get this in power bi. Community didn't give any useful results.
Any help would be appreciated.
Hi Ruth. I am new to your channel. I find your videos so useful. I have a particular problem in power query. I want to apply if and sumif condition at once. I know how to make if conditions , but I do not know what is the equivalent of SUMIFS in Power Query when looking up in another query. Can you please suggest something? Thanks.
The power bi community is the perfect place for those questions. Make sure you post sample data!
Hi Ruth, may i ask you the name of the line chart in the beginning of the video? I really like the way it shows name of legend right at the end of each line.
Thanks so much and have a good day
Charticulator
I will show you how to create it on my second channel today. Stay tuned!
Example:
m.czcams.com/video/7ZZTP8NJ2QM/video.html
Could we use ALLSELECTED() in the same way that VALUES() in this example?
Could you please post the database we are supposed to use in DAX Fridays, Thank you.
Absolutely, here it is:
m.czcams.com/video/k3NMIlLffrU/video.html
hi mam , can make video how many ways to create tables in power bi ???
Hi Ruth. I wonder if ALLSELECTED would produce the same results as VALUES? I'll have to test.
Let us know!
@Curbal, Hi after I finished watching the video, I still don't understand the difference between selectedvalue and values. Can you help me explain it again.
thank you !
Selectedvalue returns a number and values return a table
@@CurbalEN Thanks for your useful information. but maybe I'll have to watch this video again to understand.
Better yet, try to do it yourself and that might do it
I have a situation like this, for calculating MoM and WoW, I need to consider same period in the previous year. Let's say if I want to return MoM for August 2021, then calculation would be like (Aug_2021 sales - Aug_2020 sales)/Aug_2020 sales * 100. Like this it should be dynamic for MoM and WoW and in the view I need to display like Last 12 months for MoM % growth, and Last 13 months for WoW % growth. I achieved the calculation but not able to restrict last 12 months/13 weeks. Any help on this would be helpful.
Note: we are not supposed to use calendar table as per our requirement. So considering sales_date from data itself and I achieved WoW and MoM based on month_number and Week_Number. And based on maximum sales_date, we need to display last 12 months or Last 13 weeks.
What was the name of your second channel?
Hi Jelle,
Here is the channel and video link:
m.czcams.com/video/cSbLdv6KRxI/video.html
Really amazing videos. i need tanning video can provide me.
IF(CONTAINS(VALUES(Copy[Product]) ,Copy[Product],SELECTEDVALUE('Sales 1'[Product])),"y","n")
I thought today was weekend! Reality hurts.
😫😫