STATUS BAR in Power BI I Build your own LINEAR GAUGE

In this video I show you how to create your own, customized status bar (linear gauge) out of a simple table. How? With some DAX, custom formatting and a little bit of magic.

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

---------------------------------
⏱️ TIMESTAMPS ⏱️
---------------------------------
0:00​ Intro
0:31 Status bar support table
1:28 Adding a measure to determine the current status
3:22 Adding a measure to add a pointer / status indicator​
4:43 Turning a table / matrix into a status bar​
8:02​ Formatting the status bar
12:44 Customizing the status bar
14:52​ 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

[JejeRiseAgainst]

I love it !! really good idea, I think I will try to put this status bar everywhere :D

[ChrisSmithFW]

Can't wait to try this one out. Another great one. Thank you!

[Reventrant]

Great out-of-the-box thinking, thanks for the video.

[hashanwijerathne]

Very informative and great video (don’t know how someone can “Unlike” it )

[abubakrsaadmakyhoun]

Prefect as usual, out of box thinking :)

[VenemAcademy]

Hi Bas, as a newbie in PBI, your videos help me a lot. Thank you so much. As an exam secretary at a middle school, I built the enclosed gauge in Excel (the pointer consists of two lines of different length around a pivot point by means of a sin and cos table). It is a challenge, but is this also possible in PBI? I do find them online, but not nearly as nice ;-). I think the context is clear.
Oeps... I can't upload the picture 😞

[severik]

This is exactly what I've been looking for! Only thing that prevents me using this is when you said at 1:58, that you have already created the measure? Do I need to create that too? If so, how?

[kathir]

Hey very informative, I want to have the status bar inside my table cell., Is it possible ?

[DEMONTmx]

Loved it! But how can i deal with Blank Values? Whenever there are blank values my status will show very bad, its showing the data quality is bad hahah is there an "IFNA" or "ISNULL" option?

[longtimenosee]

Question: If I wanted to select one value of the status bar (let's say "Very Bas") and have the rest of the report update and show me everything that is considered "Very Bad" (ie the sales of April 2021) how would you do it? Should you update the sales data with a Status ID and then link it? Kudos in advance to anyone who can answer this or propose different ways

[gopichand]

Awesome thanks for sharing
You are a star ✨✨

Please share design tips

[niladribhowmik]

Great idea! I see your default pointer value is at 3 or 4. Do you have a filter on? How is the 'Status bar' table related to the table in which the 'DifferencetoForecast' measure exists? Thanks!

[alicedwonderland]

Excuse me while I like and save for later all of your videos :)

[gpkiindi]

absolutely wonderful if i needed to create and maintain it ... but what worries me with such visuals is what if someone else has created it and passed to me for changes/maintenance ... how may i reverse engineer it then to figure out what's going on ? it's not like a conventional code which i can read or execute in steps to find out behind the scenes..

[sahanchamod]

Good video, can you advise how to do this for continuous values, not discrete

[stevewilliams]

Hi Baz, Great Video. Unfortunately the download link isnt working.

[debbietinkler]

Hi fantastic however I can’t resize the finished product any ideas?

[BernatAgulloRosello]

Hey, how do you input emoji in there? Switch to japanese keyboard??

[Baldur]

Some strange problem is appearing. I cannot drag and drop the columns created by Enter Data (Status Id and Status Description) to values (no problem with measures - pointer and status). Is there was some PBI Update that prevents this

[yntx]

hey, great work again.

I get an error when i follow your learning path, could you please fix it? =)

Edit: Same with your Download Link.

Greetings