Forum Discussion

alexbalazsalex's avatar
alexbalazsalex
Helper IV
8 years ago
Solved

Urgent Support for matrix table

  Dear all .. not very good with Power Bi and need your support to re create the above table in matrix table :   Bellow is may data :   Year_Month Product Customer Real PCS Bdg PCS ...
Need Help
  • MFelix's avatar
    MFelix
    8 years ago

    Hi alexbalazsalex,

     

    You can do the grouping base on the column in two ways:

     

    1. Advance Query Editor

    • Add conditional column and place the following code:

     

    2. In front end

    • Select the column you and and right click or ... and choose New group
    • On the next window select the value to group and choose the names
    • Then add this to the columns in the matrix.

     

    In attach is the PBIX file for download (this is a WeTransfer and it's only available 7 days)

     

    Any further questions please tell me.

     

    And sorry for the delay.

     

    Regards,

    MFelix 

     

     

alexbalazsalex's avatar
alexbalazsalex
Helper IV
8 years ago

Hi MFelix,

 

thanks for your patiente and suport ..

 

And this unpivoting can be done stragit in Power bi ? or have to be done before as i ve seen tha tyou have "Type" column in you attached fiel already ..

 

 

Thanks Alex

MFelix's avatar
MFelix
Super User
8 years ago

Hi alexbalazsalex,

 

This unpivoting is done in the query editor.

 

If you go to the PBIX file I shared you can check how it works.

 

Any questions please tell me

 

MFelix