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.

     

YJ's avatar
YJ
Resolver II
6 years ago

can you attach the excel file?

thanks