0

I have data as per the input:

enter image description here

And in PowerBI I'm trying to create a dynamic bar chart (initially) then ideally into a heat map, but PowerBI just isn't calculating it. I'd like the output to be something like:

enter image description here

But its not workable in PowerBI. I've tried to create a matrix and the columns don't total for Poor, Very Poor etc. and are identical.

enter image description here

What can I do to overcome this?

DrewSmith
  • 47
  • 1
  • 6
  • 1
    Best way to overcome it is to unpivot your source data. In PowerQuery window, select the ID column and then Unpivot Other Columns. you end up with (ID, Grade, ). I renamed to "Rating". Then add a measure, Frequency:=countrows('Schoolratings Table') Then I dropped a matrix on the canvas. Grade is on Columns, Rating on Rows, Frequency is in Values. Then you can create the heat map. Click on the matrix then go to Formatting pane, then open Cell Elements. Turn background color ON. Then change the colors so maybe blue is low, red is high. For the Series, choose Frequency – Pieter Jul 08 '23 at 01:12

0 Answers0