Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
DFA
New Member

Combination of matrix and bar chart visual

Hi,

 

I’m looking for something like a matrix visual but with bar charts instead of values (one bar chart per matrix row).
The bar charts should represent budget vs actual per matrix row, where any deviation from budget should either be marked with green (actual is lower) or red (actual is higher).

It would be nice to have the budget in the visual as well, however, it’s not required.

 

This is a very crude sketch:

DFA_1-1664473566586.png

 

 

I’ve gone through quite a few visuals, but nothing really matches the requirements.


The closest I’ve come is properly the data bars conditional formatting on a standard matrix, but the min and max values should be relative to values on the matrix rows and not the column total.

 

 

Any recommendation on a visual would be greatly appreciated,
Thanks.

1 REPLY 1
amitchandak
Super User
Super User

@DFA , Refer to the approach I used here. You might need a different kind of measure

 

The matrix as Project plan Visual: https://youtu.be/R25QoiyoSVs

 

How to do conditional formatting by measure and apply it on pie?
https://www.youtube.com/watch?v=RqBb5eBf_I4&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L
https://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/...
https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pan...

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.

Top Kudoed Authors