cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Power Participant

## Percentage Bar Visual - Similar to progress bar.

I have multiple columns that contain either "Yes" or "No" and would like to display a visual similar to the below where it will show a percentage of all the "Yes" values in each column.  So, if there were 100 rows in the "eSIM" column and 20 "Yes" values, it would show the bar gague full by 20%

Firstly, is there a visual that can do this? I have look in the visual store and couldnt see one.  There are curved gauges, but not bars. And then what would the calculation be to get this result.

1 ACCEPTED SOLUTION
Community Support

``````Measure =
Var Yes = CALCULATE(COUNT('Table'[Category]),FILTER(ALL('Table'),'Table'[Category]=MAX('Table'[Category])&&'Table'[Status]="Yes"))
Var Total = CALCULATE(COUNT('Table'[Category]),FILTER(ALL('Table'),'Table'[Category]=MAX('Table'[Category])))
return
Yes/Total``````

Then we build a table visual and format the conditional formatting as below.

You need to change the Min and Max as 0 to 1 or the result will show incorrectly.

You can download the pbix file from this link: Percentage Bar Visual - Similar to progress bar.

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

4 REPLIES 4
Super User
Power Participant

Thanks again, you always seem to be helping me.  I will have a read of the webpage.

Community Support

``````Measure =
Var Yes = CALCULATE(COUNT('Table'[Category]),FILTER(ALL('Table'),'Table'[Category]=MAX('Table'[Category])&&'Table'[Status]="Yes"))
Var Total = CALCULATE(COUNT('Table'[Category]),FILTER(ALL('Table'),'Table'[Category]=MAX('Table'[Category])))
return
Yes/Total``````

Then we build a table visual and format the conditional formatting as below.

You need to change the Min and Max as 0 to 1 or the result will show incorrectly.

You can download the pbix file from this link: Percentage Bar Visual - Similar to progress bar.

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Power Participant

That worked great and once I pivioted the required columns, your steps worked perfectly.

Thanks very much.

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

#### Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors