This is excellent. I will be using this approach to build all future KPI's. The lack of flexibility with the default KPI visual makes it almost useless.
Thank you for the video. I manage to build the same KPI in your pbix file. It was not fast - lot of details but now I can. Thanks. Your vidoes are very interesting
This helped me immensely. I was trying to use the default KPI visual but couldn't make the trend work properly and it wouldn't look as good anyway. Tks for the content, great help!
really easy to follow; i just started wit PBI and these videos are great! a bit of help. i follow exactly the creation of the icon measures but the arrow don’t change. alway point up. any suggestions?
I really like your videos 😍 they are very helpful for me that I'm a newbie on pwbi. Can you make a video to explain how to compare this month Vs previous month? I mean,I can't understand how to say to the bi: each time I select a month you must compare it Vs previous month. Thanks
thanks Angelo! Happy to hear they help! You can do it as follows: - Measure1 Total Sales: SUM(Sales) - Measure2 Total Sales Previous Month: CALCULATE([Total Sales], DATEADD( dimDate[Date], -1, MONTH )) - Measure3 Total Sales Month over Month: [Total Sales] - [Total Sales Previous Month] While starting of with DAX it might be helpful at the beginning to also use the quick measures Hope that helps
Nice video! Very useful. In 3:38, in the text box, many times a red line appears. And some of them it remains for ever. Do you know how to deal with it? Thanks!
Hello just a quick question looks like that on the new version of Power Bi the conditional format for text is not possible Version: 2.109.642.0 64-bit (September 2022), any idea how we can go around. thanks
Woow really got to learned very useful stuff thank you Question how the year +month slicer showing year +month name on slicer header is it by default or u did some formating to get that.
You can pull the two fields Year and Month to the slicer and you get Year Month. If you click View more there is a link to the PBIX file where you can see how it done.
Can you please tell me why this wont work for me on my end? Liq - MoM Icon = VAR IconPositive = UNICHAR(9650) VAR IconNegative = UNICHAR(9660) VAR Result = IF( SUM(iBodyLibrary[Liquid Cost to Refinish Labour Sales]>[Previous Period Liq], IconPositive, IconNegative ) RETURN Result
Another quality “just in time” video I’ve bookmarked because I need it for my own project! Thanks!
so nice to hear you're implementing it! 😃 👊
This is excellent. I will be using this approach to build all future KPI's. The lack of flexibility with the default KPI visual makes it almost useless.
Right? I'm new to PowerBI but you really have to abuse the shit out of the KPI visuals if you even want to have an drill through ability.
Thank you for the video. I manage to build the same KPI in your pbix file. It was not fast - lot of details but now I can. Thanks. Your vidoes are very interesting
awesome! 😃👊 second time will be a lot faster though!
Jai ho guru ji ki.🎉❤
This helped me immensely. I was trying to use the default KPI visual but couldn't make the trend work properly and it wouldn't look as good anyway. Tks for the content, great help!
Im 3 years late, but this was amazing! it is exactly what i needed.
really easy to follow; i just started wit PBI and these videos are great! a bit of help. i follow exactly the creation of the icon measures but the arrow don’t change. alway point up. any suggestions?
Thanks for sharing! 🫡🫡
I really like your videos 😍 they are very helpful for me that I'm a newbie on pwbi. Can you make a video to explain how to compare this month Vs previous month? I mean,I can't understand how to say to the bi: each time I select a month you must compare it Vs previous month. Thanks
thanks Angelo! Happy to hear they help! You can do it as follows:
- Measure1 Total Sales: SUM(Sales)
- Measure2 Total Sales Previous Month: CALCULATE([Total Sales], DATEADD( dimDate[Date], -1, MONTH ))
- Measure3 Total Sales Month over Month: [Total Sales] - [Total Sales Previous Month]
While starting of with DAX it might be helpful at the beginning to also use the quick measures
Hope that helps
Ingenious! Thank you for sharing!
thank you Angela! 😊
You just have to appreciate the video editing
Oh so nice you mention that... the editing takes longer than the prep + recording 😅
@@HowtoPowerBI It is very obvious 😂
Good one 👍
Thanks ✌️
Nice video! Very useful.
In 3:38, in the text box, many times a red line appears. And some of them it remains for ever. Do you know how to deal with it? Thanks!
that is auto spellcheck, you can't turn it off. However if you go to another page and then back it isnt there - also not when you publish the report.
Big fan sir, you could let me know how to apply above logic for mom profit % change
Hello just a quick question looks like that on the new version of Power Bi the conditional format for text is not possible Version: 2.109.642.0 64-bit (September 2022), any idea how we can go around. thanks
Woow really got to learned very useful stuff thank you
Question how the year +month slicer showing year +month name on slicer header is it by default or u did some formating to get that.
You can pull the two fields Year and Month to the slicer and you get Year Month. If you click View more there is a link to the PBIX file where you can see how it done.
@@AmdiSilword thank you
you can create a date hierarchy and place it on a slicer. Then in the top right corner of the slicer click on v and choose dropdown list. That's it 🙂
how can i get that a dataset?
Can you please tell me why this wont work for me on my end?
Liq - MoM Icon =
VAR IconPositive = UNICHAR(9650)
VAR IconNegative = UNICHAR(9660)
VAR Result =
IF(
SUM(iBodyLibrary[Liquid Cost to Refinish Labour Sales]>[Previous Period Liq],
IconPositive,
IconNegative
)
RETURN
Result
Missing closing bracket for the sum function
Your a legend!
Hi Bas,
Can we expect other Practice Rounds? in future ??
right now not in planning:)