Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi I need some help with progress bars. Thank you so much in advance to anyone that takes the time to help me.
I will like to be able to track the progress of 3 task each with 3 milestones (not started, in progress and completed) for multiple pupils. I will paste the sample tables below which I have in power bi as well as the kind of visual I would like. Also please could you let me know what the relationship between the 2 tables should be just so I can check I have that right.
Solved! Go to Solution.
Hi @victoriashenton ,
We can use the condition format in matrix visual to meet your requirement, but the progress bars is the round.
OR you can try to use the measure
ProgressBar = SWITCH ( MAX ( 'StatusTable'[Status ID] ), 1, UNICHAR ( 9646 ) &UNICHAR ( 9647 ) & UNICHAR ( 9647 ), 2, UNICHAR ( 9646 ) & UNICHAR ( 9646 ) & UNICHAR ( 9647 ), 3, UNICHAR ( 9646 ) &UNICHAR ( 9646 ) & UNICHAR ( 9646 ) )
We can also use the bullet visual, please refer to this similar thread: https://community.powerbi.com/t5/Desktop/How-to-get-a-way-to-make-a-Progress-bar/td-p/94612
BTW, pbix as attached.
Best regards,
Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @victoriashenton ,
We can use the condition format in matrix visual to meet your requirement, but the progress bars is the round.
OR you can try to use the measure
ProgressBar = SWITCH ( MAX ( 'StatusTable'[Status ID] ), 1, UNICHAR ( 9646 ) &UNICHAR ( 9647 ) & UNICHAR ( 9647 ), 2, UNICHAR ( 9646 ) & UNICHAR ( 9646 ) & UNICHAR ( 9647 ), 3, UNICHAR ( 9646 ) &UNICHAR ( 9646 ) & UNICHAR ( 9646 ) )
We can also use the bullet visual, please refer to this similar thread: https://community.powerbi.com/t5/Desktop/How-to-get-a-way-to-make-a-Progress-bar/td-p/94612
BTW, pbix as attached.
Best regards,
Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
That's great thank you very much for the assistance. It was just what I was looking for!
can you attach the excel file?
thanks