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,

 

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