Forum Discussion
Power ParticipantPercentage 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.
Thanks in advance.
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/TotalThen 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
- amitchandak
Super User
StuartSmith , This seems like conditional formatting data bars in matrix visual.
StuartSmithThanks again, you always seem to be helping me. I will have a read of the webpage.
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/TotalThen 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.
