Forum Discussion

victoriashenton's avatar
victoriashenton
Frequent Visitor
6 years ago
Solved

Progress bars

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 s...
Need Help
  • v-lid-msft's avatar
    v-lid-msft
    6 years ago

    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.

     

v-lid-msft's avatar
v-lid-msft
Community Support
6 years ago

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.

 

  • victoriashenton's avatar
    victoriashenton
    Frequent Visitor
    6 years ago

    That's great thank you very much for the assistance. It was just what I was looking for!