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

 

i checked your option ... but i ve seen that you multiplied each row by type for each date ... in my case in a db of 100k rows ... it would be difficult..

 

Do you think there is other way around it ? or just this way ?

 

Many Thanks.

Alex

MFelix's avatar
MFelix
Super User
8 years ago
Hi alexbalazsalex,

Don't understand your question. The unpivot of columns will make a single row for each attribute (is what you refer as multipying??) because as said before you can't have the data with a title and subtitle within measures.

In terms of performance by the PBI model you should not have big issues since everything is done when refreshing the model, again this is just a workaround to give the title/ subtitle since you can't use measures in the hierarchy.

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