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 Felix

 

thanks for the reply ,

 

any ideas how i should add in the matrix the columns,

 

to show

 

Metrics like Invoicing USD Mill and then under real vs Bdg.

Volume Th Pcs real than real vs BDg ... this is my main doubt

alexbalazsalex's avatar
alexbalazsalex
Helper IV
8 years ago

Hi MFelix,

 

Any ideas on how to proceed ?

 

Many Thanks

Alex

  • alexbalazsalex's avatar
    alexbalazsalex
    Helper IV
    8 years ago

    Dear All,

     

    Could you please advise ? Getting nowhere unfortunalty ...

     

    Thanks

      • MFelix's avatar
        MFelix
        Super User
        8 years ago

        Hi alexbalazsalex,

         

        Today I'm dealing with some urgent work related issues. Will get into this later this evening and will try to provide an answer ASAP.

         

        Regards,

        MFelix