Visualize rating with multiple categories

[panosp_ergo]

Dear,

i have a problem to customize my data to visualize through POWER BI.
I have a table with records such the folowing

record_id...........humidity............sunlight...........temperature
1...........................rate1.....................rate2................rate1
2...........................rate2.....................rate1................rate3
3...........................rate3.....................rate3................rate3
4...........................rate2.....................rate4................rate5
5...........................rate4.....................rate3................rate4
etc

with rateX means a number between 1 - 5..

So i want if it is possible in a table with 1453 records to visualize
all or only the selected records based on category (humidity............sunlight...........temperature)
and present (with stacked bars or radar) how many of filtered records have Humidity with rate =1 how many with rate=2 etc
and in the same diagram how many of filtered records have Temperature with rate =1 how many with rate=2 etc

Do i have to transform my table, or something else more simple ?

Thanks in advance
Panos

[v-diye-msft]

Hi @panosp_ergo 

Do you mean you'd like to sort the table by multiple columns?

You should probably refer to the similar threads:

https://community.powerbi.com/t5/Desktop/How-to-order-by-column-name-and-measure-value/m-p/860531#M4... 

https://community.powerbi.com/t5/Desktop/Sorting-by-multiple-columns/m-p/536884#M251918 

[Greg_Deckler]

I would recommend right-clicking record_id in Query Editor and Unpivot other columns. Then the things you are trying to do will probably be a lot easier.