Double Heading Matrix

[estefaniamc]

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

[Abduvali · Accepted solution]

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

[Rose_T]

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

[shanelthiggs]

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]

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]

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

[v-yulgu-msft · Accepted solution]

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

[Abduvali · Accepted solution]

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