How to use multi-columns of ranked category (technics implemented) within one visual like tree map

[ZistaKely]

Dear folks, I have a data where there are multi-columns (11 ones) where are listed form a choice list from the raw data of ranked category (Agriculture technics implemented here). So, I want to use them within one visual, I tried with the tree map where I have inserted all of the ranked columns (CSA/EbA Technic 1 to 11) within the Category or the visual only use the first field as the CSA/EbA Technic 1 instead of the sum of the countvalue of all the technics listed from 1 to 11 (in the table below).

So, I want to ask your help to guide me if it is necessary to create a sub-table (if that could exist in PBI) or immediately to use all of these many columns from list of choice to count each value listed and use them within the one visual.

Thank you in advance for your help.

[v-easonf-msft]

Hi, @ZistaKely 

Not entirely sure what you want, but if I calculate specific values for multiple columns, I will give priority to creating a sub-tables in Power Query so that I can simplify the model through features such as ‘Unpivot' and 'GroupBy'.

Best Regards,
Community Support Team _ Eason

[ZistaKely · Accepted solution]

Dear,

Yes, I think that is what I want to achieve with this data and the visual after i-e count all the apparitions / uses of the different "CSA/EbA technics" for the multiple columns and represent them within one visual after.

Best regards,