cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Combined matrix and horizontal bar chart

Hi all,

 

My requirement is to build a combined horizontal bar chart + matrix.

 

rigosakhx_0-1652759753762.png

Source data is as follows

rigosakhx_1-1652759941488.png

 

My understanding is that the most viable solution would be using SVG, however, I am yet to understand if it is possible to color bars based on the category.  

3 REPLIES 3
Shashi_Kant82
Frequent Visitor

did you find any solution for this?

 

isabella
Microsoft
Microsoft

Hi @Anonymous 

I think you can use table and stacked bar chart to achieve your requirement  in power bi  desktop

isabella_0-1653013828909.png

 

Here is my test table

isabella_1-1653013828911.png

 

The avg score is a measure  

avg score = AVERAGE([score])

 

Format the label on the stack bar

isabella_2-1653013828912.png

 

Change the color of the bar

isabella_3-1653013828913.png

 

Open the total labels

isabella_4-1653013828913.png

 

Best Regards,

Community Support Team _Isabella

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

JoaoMarcelino
Super User
Super User

Hi @Anonymous ,

I used your small data example and created a table:

JoaoMarcelino_0-1652782667418.png

Then I wrote an average measure to iterate the whole table, to scan each row of the column:

Average Score = AVERAGEX('Table', 'Table'[Score])

After that:
Example 1 - I choose a table chart and dragged these two fields:
JoaoMarcelino_1-1652782892082.png

To give color to the cells, you need to do this:

JoaoMarcelino_2-1652783139154.png

Example 2 - If you want to make a bar chart, to segment each column but the category of "Overall score group", you need to do the following: Click on Stacked bar chart, place these fields as shown below with Overall score group on the Legend field.

JoaoMarcelino_3-1652783319325.png
To get rid of the Y-axis and title, choose the chart and click here:
JoaoMarcelino_6-1652783488966.png

Finally, to activate data labels and total labels, write on search "Labels" and choose the following:

JoaoMarcelino_7-1652783600134.png

Here you will fill the example if you need to explore and test 🙂 https://we.tl/t-VyK84gWXPa

Hope I was of assistance!
Cheers
Joao Marcelino
Ps- Did I answer your question? Mark my post as a solution! Kudos are also appreciated 🙂






Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors