Forum Discussion

estefaniamc's avatar
estefaniamc
Frequent Visitor
8 years ago
Solved

Double Heading Matrix

Hi All,

 

I am trying to do a matrix as in the picture below, but within each month I would like to include columns that distinguish version (Outlook or Actual values). For instance I want to see all row values for January with the two values (Outlook & Actual) for my two different versions. At the same time, when I drill up, I would like to see the same for each Quarter. Is it possible to do so? 

This is the one I have now

This is how I would like it to be

 

 

Many thanks in advance,

 

Regards

 

Estefania

 

 

 

Need Help
Tips and Tricks
  • Abduvali's avatar
    Abduvali
    8 years ago

    Hi estefaniamc,

     

    Use Matrix table and then drop your fields as follows:

    • Step 1

     

    • Step 2

    Align Center your Headers and Values

     

     

     

     

    Hope this solves your issue.

     

     

    Regards

    Abduvali

     

     

  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi estefaniamc,

     

    Yes. It's available to create such a Matrix.

     

    Add date hierarchy into column section, remove "Year" and "Day" values.

     

    By default, the top group level is Quarter. To drill down to Month level, click the second "Drill Down" icon.

     

    To show both Quarter and Month level as column header, you could click the third "Drill Down" icon.

     

    Best regards,

    Yuliana Gu

7 Replies

  • Abduvali's avatar
    Abduvali
    Skilled Sharer
    8 years ago

    Hi estefaniamc,

     

    Use Matrix table and then drop your fields as follows:

    • Step 1

     

    • Step 2

    Align Center your Headers and Values

     

     

     

     

    Hope this solves your issue.

     

     

    Regards

    Abduvali

     

     

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    8 years ago

    Hi estefaniamc,

     

    Yes. It's available to create such a Matrix.

     

    Add date hierarchy into column section, remove "Year" and "Day" values.

     

    By default, the top group level is Quarter. To drill down to Month level, click the second "Drill Down" icon.

     

    To show both Quarter and Month level as column header, you could click the third "Drill Down" icon.

     

    Best regards,

    Yuliana Gu

  • shanelthiggs's avatar
    shanelthiggs
    Regular Visitor
    8 years ago

    Hi All,

     

    Is it possible to create the matrix demonstrated, but instead of the [Actual] and [Outlook] columns existing per quarter, have the quarters exist per each of those value headings.

     

    So, instead of having Option 1, you would have Option 2 (both below).

     

     

     

     

     

    Thanks

    Shane

    • estefaniamc's avatar
      estefaniamc
      Frequent Visitor
      8 years ago

      Thanks for your suggestion shanelthiggs but the problem comes when I tried to calculate the difference between actual and outlook per Region.

       

      I managed to calculate it by creating new columns and add some measures that can be filtered through different supporting tables that I created. 

       

      Regards, 

       

      Estefania

       

      • shanelthiggs's avatar
        shanelthiggs
        Regular Visitor
        8 years ago

        Hi estefaniamc - apologies, I was more tagging on to your original question in the hope of finding one myself; not much of a solution I know.

         

        My desired format (Option 2 in my image) is something we can do on an existing SSAS product but can't seem to replicate that format in Power BI. The below images are what we would have in our existing product; its' effectively making the measures' headings primary, and the dimensions' headers secondary.

        Dimension Headers Primary / Measures Headers SecondaryMeasures Headers Primary / Dimensions Headers Secondary

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

        Hope that clarifies a little more what I was after.

         

        Cheers

        Shane

  • Rose_T's avatar
    Rose_T
    Frequent Visitor
    2 years ago

    Thanks for your contribution, it helped resolve my issue as well 🙂