Power BI Practice Solution ROUND #10 I CUSTOM KPI CARDS

[@famousjamous2006]

Another quality “just in time” video I’ve bookmarked because I need it for my own project! Thanks!

[@HowtoPowerBI]

so nice to hear you're implementing it! 😃 👊

[@totvabe1]

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!

[@HowtoPowerBI]

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.

[@jeremy8626-r6b]

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.

[@bryans5878]

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.

[@chinesejs]

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?

[@slowchrno]

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!

[@AmdiSilword]

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

[@HowtoPowerBI]

awesome! 😃👊 second time will be a lot faster though!

[@omnarayan7066]

Jai ho guru ji ki.🎉❤

[@ryner4961]

Im 3 years late, but this was amazing! it is exactly what i needed.

[@mohdmuzammil3059]

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.

[@AmdiSilword]

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.

[@mohdmuzammil3059]

@@AmdiSilword thank you

[@HowtoPowerBI]

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 🙂

[@imxltf]

Thanks for sharing! 🫡🫡

[@catalinatobonfernandez5689]

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

[@growithgogoyo]

how can i get that a dataset?

[@angelaroi833]

Ingenious! Thank you for sharing!

[@HowtoPowerBI]

thank you Angela! 😊

[@carax006]

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

[@HowtoPowerBI]

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

[@toirshad]

Good one 👍

[@HowtoPowerBI]

Thanks ✌️

[@mitchelboyle4500]

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

[@HowtoPowerBI]

Missing closing bracket for the sum function

[@mitchelboyle4500]

Your a legend!

[@hiteshjoshi3148]

Big fan sir, you could let me know how to apply above logic for mom profit % change

[@BolajiBI]

You just have to appreciate the video editing

[@HowtoPowerBI]

Oh so nice you mention that... the editing takes longer than the prep + recording 😅

[@BolajiBI]

@@HowtoPowerBI It is very obvious 😂

[@madhusudhan9673]

Hi Bas, Can we expect other Practice Rounds? in future ??

[@HowtoPowerBI]

right now not in planning:)