Forum Discussion
m4kaveli
5 years agoFrequent Visitor
Transpose Results Question
Hi guys, Having trouble figuring this out.... Trying to transpose the following. How do I get the results in table one to show like this in table 2 I tried a variety of IF statements but I keep ...
- 5 years ago
m4kaveli , In matrix line on row , Screen order on column, Max of Uniq producer on Value .
Or Unpivot in Power Query
https://radacad.com/pivot-and-unpivot-with-power-bi
Transpose : https://yodalearning.com/tutorials/power-query-helps-transposing-data/
m4kaveli
5 years agoFrequent Visitor
Thanks. I was able to use the Matrix visual as you suggested and used the formatting to remove subtotals and turn off the stepped layout. This is exactly what I am looking for. Thanks! amitchandak