cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Responsive Resident
Responsive Resident

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%

 

2020-09-15_10-45-04.jpg

 

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Percentage Bar Visual - Similar to progress bar.

Hi @StuartSmith 

In addition to 

 

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.

2.png

3.png

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. 

 

View solution in original post

4 REPLIES 4
Highlighted
Super User IX
Super User IX

Re: Percentage Bar Visual - Similar to progress bar.

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

Data Bar.png



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Highlighted
Responsive Resident
Responsive Resident

Re: Percentage Bar Visual - Similar to progress bar.

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

 

Highlighted
Community Support
Community Support

Re: Percentage Bar Visual - Similar to progress bar.

Hi @StuartSmith 

In addition to 

 

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.

2.png

3.png

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. 

 

View solution in original post

Highlighted
Responsive Resident
Responsive Resident

Re: Percentage Bar Visual - Similar to progress bar.

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

Thanks very much.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors