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 a...
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

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