Combined matrix and horizontal bar chart

[Anonymous]

Hi all,

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

Source data is as follows

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.  

[Shashi_Kant82]

did you find any solution for this?

[isabella]

Hi @Anonymous 

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

Here is my test table

The avg score is a measure  

avg score = AVERAGE([score])

Format the label on the stack bar

Change the color of the bar

Open the total labels

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]

Hi @Anonymous ,

I used your small data example and created a table:

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:

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

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.

To get rid of the Y-axis and title, choose the chart and click here:

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

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 🙂