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!
Download file here datatraining.io/powerbi-how-to
--------------------------------
📊 TRAININGS 📊
---------------------------------
Power BI Design 4 Weeks Transformation Program my.datatraining.io/pages/powe...
Power BI Essentials datatraining.io/powerbilearni...
Business User Training datatraining.io/powerbi-busin...
For Custom Trainings and Consulting email directly support@datatraining.io
---------------------------------
⏱️ 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 😍
----------------------------------
Join bit.ly/4b453bi
Subscribe bit.ly/31MnQGO
Insta / howtopowerbi
LinkedIn / basdohmen
TikTok / how.to.power.bi
X / howtopowerbi
fb / howtopowerbi
Threads www.threads.net/@howtopowerbi
Newsletter datatraining.io/newsletter
---------------------------------
👇 CHECK THIS OUT! 👇
---------------------------------
💻 My gear amzn.to/47F21Yc
📚 Power BI books MUST READ! amzn.to/3tUfFcj
💡 General books I recommend amzn.to/48YNo33
🎶 Music for my videos www.epidemicsound.com/referra...
🚀 For growing on KZread: www.tubebuddy.com/bas
🏄 Stuff I use daily amzn.to/3HqfMQ2
* 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
Пікірлер: 57
Thank you so much for all your videos!
This is soooo good Bas - thank you
Thank you very much. Clear and peaceful !!!
@HowtoPowerBI
2 жыл бұрын
:):) thanks a lot 👍
All your videos are so great
Thanks Bas! Looks awesome, I was still typing out my measures but this seems a lot easier.
@HowtoPowerBI
2 жыл бұрын
happy to hear it's helpful! 😀
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.
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.
Definitely going to give that a try
@HowtoPowerBI
2 жыл бұрын
I hope it worked out! 😀
Excellent video. Maybe it would be interesting too to do it without tabular. Thanks for sharing.
Excellent Video, thank you
@HowtoPowerBI
2 жыл бұрын
You are welcome! Happy to hear you find it useful
Very useful and nice trick, I ♥ it so much!
@HowtoPowerBI
2 жыл бұрын
Thx Thành!! 😀
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.
THANKS, Excellent
@HowtoPowerBI
2 жыл бұрын
Thanks for watching Juan! 😀
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)
👍👍👍👍👍 Nice. Thanks for sharing.
@HowtoPowerBI
2 жыл бұрын
Thanks for watching again!! 😀
Great video, I've a question please, how to use the KPI Status to count the (-1) and present them as a card?
Thanks!
@CinnamonBuns19
2 жыл бұрын
Loving the content, keep it up!
@HowtoPowerBI
2 жыл бұрын
thank you so much for your support of the channel, it means a lot to us to hear it is helpful and enjoyable. More is coming, stay tuned :)
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
thanks
@HowtoPowerBI
2 жыл бұрын
thx for watching!!! 😀
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
Can it be done without tabular editor?
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
Nice 👌
@HowtoPowerBI
2 жыл бұрын
thank you Sravan!!! 😀
Cool useful 😃
@HowtoPowerBI
2 жыл бұрын
Thanks a lot!
How can we create a measure to change the color of a column that represents the maximum value automatically?
One more helpful video. Thanks Bas :). Would you continue doing it with Tabular editor after the October 2023 calculation feature?
@HowtoPowerBI
7 ай бұрын
i don't think you can add kpis yet in power bi itself (only calculation groups was added)
How you get sales forecast?
Can you share the dataset I mean the excel/csv data?
I am not able to create KPI in Tabuler 3, i have installed Trial version
Is tabular editor the same as DAX studio?
in this case, could you please tell me --- how to get sales forecast?
@saifashraf9714
Ай бұрын
did u know how?
How to take total forecast measure
@HowtoPowerBI
4 ай бұрын
see link to download file in the description
Any tutorial without external tools? My company disables them
@HowtoPowerBI
Ай бұрын
no, for now only possible with external tools
Is this video updated?
Please explain M language from scratch
for the reason as to why to use KPI go to 12:47 xD
But Tabular Editor isn't free... Not after the first 30 days :(
@vladsamoilov9905
2 жыл бұрын
you can have free version as well
The presenter is attractive the tool is not by pity - neither powerBi nor that „brake your fingers“ Threshold editor…. The only thing i like about power BI is that it offers anti-join oob.
@HowtoPowerBI
2 жыл бұрын
Hi Jan 🙂 look into alternatives like Tableau - maybe it's more your cup of tea
Prachtige filmpjes Bas, mooi en duidelijk add me ff op linkedin