Visualize rating with multiple categories

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