Forum Discussion
Create View from existing table
Hi, I´m new to Power Bi and i need some help, so I hope you can help me. I have a table which looks like that: Juni Juli Aug Sept Okt Nov Dez x x x x x x x x 1 1 1 1 0 0 ...
Anonymous - So if that is your source table, generally you would want to unpivot those columns in Power Query. Then things should be pretty easy.
Hi Anonymous ,
1. Select all of your column and use Unpivot columns in power query editor, close and apply it.
2. Put the new fields in a matrix visual, set the value field as count of values to get the expected result:
Best Regards,
Yingjie LiIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous - So if that is your source table, generally you would want to unpivot those columns in Power Query. Then things should be pretty easy.