Analyzing feedback data with 40 Yes/No columns

[PeterStuhr]

Hi all,

I have a dataset with 40 1/0 (Yes / No) columns.

Example like:

Since there are so many categories, I have a hard time figuring out how to display it.

My idea is maybe to "Rank" the sum of each category.

So based on the filtering, you can always see which category has the biggest frequency etc.

How would I do this, when it is different columns?

Thanks!

[PeterStuhr]

Hi @amitchandak thanks

I also found another way using generateseries table.

[amitchandak · Accepted solution]

@PeterStuhr , On way, is unpivot those 40 columns

Unpivot Data(Power Query) https://www.youtube.com/watch?v=2HjkBtxSM0g&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=11

https://radacad.com/pivot-and-unpivot-with-power-bi