Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Combined matrix and horizontal bar chart

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, ho...
Need Help
Tutorial Requests
JoaoMarcelino's avatar
JoaoMarcelino
Icon for Responsive Resident rankResponsive Resident
4 years ago

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 🙂