Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Custom Headers in matrix

Hi Friends,

 

Can anyone please help me how to create a matrix with custom headers.

I'm trying to replicate excel reports into Power BI.

 

There are few Custom Headers for measures in excel reports, need to build the same in power bi.

 

StateID and Distributor are Dimensions.

Ships, Intransit, Store, Godown are Measures, should come under "Stock In Hand".

CurrentMonth, PreviousMonth, Rolling6 Months and Rolling12 Months are Measures, should come under "Rates".

 

How to build the above matrix in Power BI.

 

Regards,

Pavan

Need Help
Tips and Tricks

4 Replies

  • v-juanli-msft's avatar
    v-juanli-msft
    Icon for Community Support rankCommunity Support
    8 years ago

    Hi Anonymous

    Does your dataset look like this? if not, could you show how your table structure?

    col1 col2 col3 col4 col5 col6 mes1 mes2 mes3 mes4 mes5
    StateID Distributor Ships Intransit Store Godown CurrentMonth PreviousMonth Rolling6 Months Rolling12 Months

     

    I'm afraid in this case it is not possible to get the matrix as you required, we must make some changes to the data structure (create a new table based on this table which has a different data structure), could you accept this change?

     

    Best Regards

    Maggie

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hi,

       

      Thanks for your quick reply.

       

      Actually datasource is SQL and can't share the screenshot, and can't change the data structure also.

       

      Can you please suggest any other way to acheive this in power bi.

       

      Thanks In Advance.

      • v-juanli-msft's avatar
        v-juanli-msft
        Icon for Community Support rankCommunity Support
        8 years ago

        Hi Anonymous

        Do you import the data to power bi or use direct query?

        If you use import mode, we can make change within powre bi.

         

        Best regards

        Maggie