Visualizing Status Tracking Data in Power BI

In this video I show how to create a status tracker. This super useful visual can for example be used to show in what stage of the sales funnel a potential client is, or at what stage in the delivery process a package is. Step by step I go over the different visualisation tricks to set it up, using only native visuals in Power BI.
Enjoy this video and subscribe to always stay updated on my favorite Power BI tricks :)

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

---------------------------------
⏱️ TIMESTAMPS ⏱️
---------------------------------
00:00 Intro
01:11 Create a table with all stages
02:05 A Line Chart to start with
04:19 Correct order of all stages
05:40 Fill until the current stage
09:27 Add check marks
14:49 Refining the Design
16:53 Adding additional Metrics
20:18 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

[Aquaelus]

*Bas, your creativity knows no bounds; I'm continually amazed at the limitless possibilities you bring to life.*

[madluke]

Great video, as always!

Tip: if you create the disconnected table with curly brackets via DAX expression, you can use the normal sort by function in the column settings.

CurlyTable =
{
("Ordered", 1),
("Shipped", 2),
("Delivered", 3)
}

will give you the table; the columns can then simply be renamed afterward.

[brandongillins]

I switched companies about a year ago and they only used tableau. I missed all your videos because you helped me shine like a rockstar! Now that company is moving back over to PowerBi. Time to binge? Most likely!

[lppadua]

Bas, I made it. Thank you for this new visualization. I want to show you what I did but I can't paste it here. This is really amazing to use.

[amorimxv]

Visually minimalist, but very efficient and intuitive. Very good!

[alastairnaolu]

please continue to keep making videos! I love the real life application you provide with these builds.

[ErghePoston]

Hey Bas, great video as always!
I have a huge issue that seems evasive in Power BI... Change data capture, or showing new/changed records since last refresh. Think that would be a worthwhile video? Seems like something most of us could use. Thank you for all your help!

[philoooooo]

Hi Bas wonderful work ! I learned a lot.
One small improvement can be done is that you either don’t show the check mark on the order status that is not achieved yet or show another check mark that means not done !

[anishagupta]

Excellent video😍🤩 I wanted to make a request that there is a new feature that came in AWS i.e. AWS QUICKSIGHT which is also a data visualization tool . My kind request if you could make such innovative videos of how we can make the same visualizations in AWS QUICKSIGHT TOO

[keagankemp]

I am sending a petition to Microsoft let’s change the name from PowerBI to BasBI lol you are a master of your trade, thank you I needed this.

[victorsalaspsalas]

Your teaching is great, thank you very much for this new knowledge.

[timazarj]

Great as usual!
Like to have a same tracking for client retention for membership, show the date that client renewed their membership as lable

[majidgolnar]

At the end, I was a WOWWW. Thanks, such an amazing creativity

[melissarolim]

You are incredible! This helped me a lot! Thank you so much for sharing your knowledge this way!

[mathaem]

Love it as always ! Thank you from France 🙏

[narendrababu]

I would like to implement in my recruiting dashboard. This will be a great insight.

[VarshithaV-xp]

Hello Bas,
Great Video
also could you please share the data set used in this !

[yaxmokwa]

Coolest hack I have seen in long while.

[ahmedtharwat]

Really it is amazing, all your designs are amazing and out of box thanks man

[MelBoulds]

Another great visual built using native visuals. I can't get the highlight to equal 1 for previous stages in the order though, only the current status is calculated as 1.
Processing Highlight =
VAR _SelectedStatus = SELECTEDVALUE('Sales Order Lines'[StatusIndex])
VAR _SelectedStatusNr =
CALCULATE(
MAX('Processing Status'[Order]),
'Processing Status'[StatusIndex] = _SelectedStatus
)
VAR _Result =
IF(
SELECTEDVALUE('Processing Status'[Order]) <= _SelectedStatusNr,
[Baseline]
)
RETURN _Result