Forum Discussion
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 getting blank rows if the if statement fails. I know I'm missing something....
I am using Power BI desktop with Direct Query to SQL. I tried creating new columns based off of each scenario but that is where i'm getting blanks...
Thanks in advance!
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/
2 Replies
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/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
