Percentage Bar Visual - Similar to progress bar.

[StuartSmith]

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.

Thanks in advance.

[amitchandak]

@StuartSmith , This seems like conditional formatting data bars in matrix visual.

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting#add-da...

[StuartSmith]

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

[v-rzhou-msft · Accepted solution]

Hi @StuartSmith 

In addition to amitchandak's reply, you need to build a measure and then use Data Bars in Conditional Formatting.

I build a table to have a test.

Measure:

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. 

[StuartSmith]

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

Thanks very much.