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 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.

 

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.

     

3 Replies

  • YJ's avatar
    YJ
    Resolver II
    6 years ago

    can you attach the excel file?

    thanks

  • 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!