Forum Discussion

steven_osman's avatar
steven_osman
Regular Visitor
8 years ago
Solved

show multiple columns as rows with dynamic columns based on values

Hello, 

 

I have a table of values as shown below :

 

 

ABCDE
xx10.50.30.2
xx20.60.10.3
yy10.80.20
yy20.40.40.2
yy30.20.20.6

 

I need a report in power bi, for each set of column A, B as columns and C,D,E as rows. For example, For xx, the table should be : 

 

 123
C0.50.6 
D0.30.1 
E0.20.3 

 

and for yy the table would be:

 

 123
C0.80.40.2
D0.40.40.2
E0.20.20.6

 

Thanks in advance for your help.

Regards,

Steven

  • erikajain02's avatar
    erikajain02
    8 years ago

    Hi,

     

    You need to unpivot you table first. Look at the snapshot for the steps.

    I have attached sample for you to achive the required result.

1 Reply

  • erikajain02's avatar
    erikajain02
    Resolver I
    8 years ago

    Hi,

     

    You need to unpivot you table first. Look at the snapshot for the steps.

    I have attached sample for you to achive the required result.