Transpose Results Question

[m4kaveli]

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]

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 

[amitchandak · Accepted solution]

@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/