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 repo...
Need Help
Tips and Tricks
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

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Hi,

         

        I'm importing the data from SQL to Power BI.

         

        Can you please let me know the process to achieve.

         

        Thanks in Advance.

         

        Regards,

        Pavan.