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.
did you find any solution for this?
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.
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:
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.
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 🙂
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!
User | Count |
---|---|
119 | |
76 | |
65 | |
53 | |
51 |
User | Count |
---|---|
183 | |
101 | |
80 | |
79 | |
77 |