Forum Discussion

dejadpower's avatar
dejadpower
Icon for Helper I rankHelper I
3 years ago
Solved

Double Headers on Matrix

Hi There,   I need to create double headers on matrix. I have searched a lot in the community, nothing matches our scenario: My visual should look like this: But my table doesnt have specifi...
Need Help
  • BITomS's avatar
    BITomS
    3 years ago

    Hi dejadpower 

     

    I think one potential option (although I suspect not the only solution) would be to split your single fact table into 2 (i.e. one for Opening and the other for Purchase). You can do this through Power Query.

     

    You could then create a new column in each table with a standard Id (i.e. Opening = 1 and Purchase = 2), and add a dimension table with the Id and name which joins to these created columns.

     

    Then you can add the dimension name column to the 'Columns' section of your matrix visual and any values or measures calculated for each table should fall under one of the headers.

     

    Hope that helps.

dejadpower's avatar
dejadpower
Icon for Helper I rankHelper I
3 years ago

Thanks , I'm new to powerbi, Can you please share how to split the table with power query

  • BITomS's avatar
    BITomS
    Icon for Solution Supplier rankSolution Supplier
    3 years ago

    First, you can duplicate the table query:

    Then remove the Purchase related columns from one table and the Opening related columns from the other:

    This gives you the 2 Fact tables.

    • dejadpower's avatar
      dejadpower
      Icon for Helper I rankHelper I
      3 years ago

      Thank you for your time, I'll try and update

      "You could then create a new column in each table with a standard Id (i.e. Opening = 1 and Purchase = 2), and add a dimension table with the Id and name which joins to these created columns."

      -- kindly clarify , should i add new column in both tables ?