Improve your VISUALS I How to turn a MEASURE into a KPI in Power BI

In this video I show you how to turn measures into KPIs using Tabular Editor. Enjoy the video and subscribe for more videos like this!

--------------------------------
📊 TRAININGS 📊
---------------------------------

---------------------------------
⏱️ TIMESTAMPS ⏱️
---------------------------------
0:00 Intro
1:03 Turning a measure into a KPI
3:00 Writing the status expression
4:45 Adding a status graphic
5:30 Adding an upper and lower bound for the middle status
7:48 Showing no icon when there is a blank
8:45 Clean up the table / matrix visual
9:36 Adding the trend expression to the KPI
11:37 What about conditional formatting
13:11 End

---------------------------------
😍 JOIN 😍
----------------------------------

---------------------------------
👇 CHECK THIS OUT! 👇
---------------------------------

* Above are affiliate links, which means at no additional cost to you, if you make a purchase using these links we will receive a small commission. It supports us and helps us to continue making more How to Power BI videos!

Thanks for being a part of this channel and all your support! 💪 🙏

#HowToPowerBI​ #PowerBI​ #DataTraining​
#powerbidesktop​ #powerbitraining​ #powerbideveloper​ #DAX

[dcpowered]

This video made me subscribe! Excellent explanation about KPI and crystal clear. Could you please make a video to show how to do the same without installing extra software since it is not allowed on my work laptop.

[eversonjunior]

Excellent video. Maybe it would be interesting too to do it without tabular. Thanks for sharing.

[cpassuel]

Very interesting video. I just wondering why you test blank values after the comparison. It seems less optimized to me (even if the impact is minimal)

[Pjotterbolte]

Thanks Bas! Looks awesome, I was still typing out my measures but this seems a lot easier.

[juanignacioXI]

Can it be done without tabular editor?

[karikoga]

Great stuff. How can you apply this to a matrix. I have tried and i think there is some tweaking required as the status indicators will not show all way through

[lucylu]

in this case, could you please tell me --- how to get sales forecast?

[eimpksl]

Great video, I've a question please, how to use the KPI Status to count the (-1) and present them as a card?

[xyclos]

Thank you very much. Clear and peaceful !!!

[manish.nsYoutube]

Great video Bas.. Was able to associate the goal with the what if parameter.. Perfect once you also tie it to your dynamic range video.

[LearnItSimply]

Thank you verymuch for this video, I would like to understand how we can include time in KPI for Eg for call center dashboard Average Handling Time (AHT) is one of the KPI which i am unbale to show it in KPI indicator as time format, is any alternative for this

[sandeepbarge]

Thank you so much for all your videos!

[luisaymarinacruz]

One more helpful video. Thanks Bas :). Would you continue doing it with Tabular editor after the October 2023 calculation feature?

[AndresGuillermo]

How can we create a measure to change the color of a column that represents the maximum value automatically?

[teddyfabriciocordovasaenz]

Is tabular editor the same as DAX studio?

[RedGoddesscom]

Many thanks!!!
Do you have a place where ppl submit an idea for the next video ? I'll drop it here. Created a clickable card, which takes to Bookmark ( hidden page) that has a number of filters hence need to have data ticked under bookmark ( if unticked, losing all necessary filters) .However, when filter applied on the main page, filter doesn't take to the bookmark page. I know that filter would pass to the bookmark page when data is unticked... but I need it ticked! Any tricks? Thanks

[bhupoinedmonton]

I am not able to create KPI in Tabuler 3, i have installed Trial version

[Ploplox]

Any tutorial without external tools? My company disables them

[jeffchen]

Very helpful video. Could you please make a video to show how to show burndown chart based on target and actual by month? Thank you so much.

[lmt]

Can you share the dataset I mean the excel/csv data?