cancel
Showing results for
Did you mean:

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Impactful Individual

## 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
Impactful Individual

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.

Impactful Individual

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

Thanks very much.

Announcements

#### Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

#### Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

#### The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors