A visual (matrix?) with multiple columns some with numbers and some with visuals

[diogobraga2]

How is this done in Power BI? I am trying to create something similar to this screenshot below, where there are columns with numbers and a colum with a visual representation of the number, in this example a bar of % utilization rate in a 100% bar would work fine. 

So far, I got this far...

[amitchandak · Accepted solution]

In Visualization go-to format. In conditional formatting choose the metrics and use data bars. There is an advanced option if required.

https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting.

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.

My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p...

https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

[diogobraga2]

Thanks, I see this option. No bars are showing for the totals though, where is the option to enable it? 

[dax]

Hi diogobraga2,

Yes, you could choose Data Bar in conditional formating to achieve this goal. But you need to know "Conditional formatting is applied only to the values of a Matrix visual, and does not apply to any subtotals or grand totals." This is by design.

You could submit requirement in power-bi-ideas 

Best Regards,
Zoe Zhi

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