Have measure values above column hierarchy

[bundipapa]

Hello All,

for a project I would need to have the column hierarchy set to the way, that the measure headers are above the year values in the below example, just like in the Pivot next to the data. I know tableau allows the user to have the measure names above the column names in the hierarchy, so group the values first by the measure and then by the column value, but I haven't found a possibility to do the same in Power BI. Is this possible, or is there a workaround or a custom matrix option to do this?

I would need this structure, with measure names being top

instead of this with years over measure names

Thank you for any help!

[v-pagayam-msft]

Hi @bundipapa ,
I hope the suggested information helped for you. If you found any other ,please share it the community and accept your answer as solution.It will be helpful for others who are facing similar issue.If it is not resolved, please feel free to reach out!
Thank you.

[v-sgandrathi]

Hi @bundipapa,

We wanted to check if you had a chance to review our last reply. Let us know if it helped or if you need more guidance, we're always happy to help further.

Thank you.

[v-pagayam-msft]

Hi @bundipapa ,
Following up to check whether you got a chance to review the suggestion given.If still facing any issue,feel free to reach out!
Thank you.

[bundipapa]

Thank you for the answers, but I don't have that option available and when I wanted to enable it in the settings, I couldn't find it. Currently I seem to be unable to create calculation groups.

[v-pagayam-msft · Accepted solution]

Hi @bundipapa ,
Thank you for the prompt repsonse @Elena_Kalina  and @Cookistador !

This feature is available in the latest versions (June 2024+). Please check File > Options > Preview features, enable Calculation groups and TMDL model.From the screenshot, I see the TDML is not yet enabled,once enabled restart Power BI, try updating Power BI Desktop.
Here is the doc for your reference:Create calculation groups in Power BI - Power BI | Microsoft Learn 

Hope this helps.
Thank you.

[Elena_Kalina]

Hi @bundipapa 

As @Cookistador  mentioned we can use a calculation group. You need to follow the following steps:

1 Create a measures

Discount Measure = 
SUM('Table'[Discount])

Margin Measure = 
SUM('Table'[Margin])

 2 Create Calculation Group 

https://learn.microsoft.com/en-us/power-bi/transform-model/calculation-groups

where

Discount = [Discount Measure]
Margin = [Margin Measure]

3 Create the matrix 

• Drag the "Product" field to the "Rows" section

• Drag the "Year" field to the "Columns" section

• Drag both "[Discount Measure]" and "[Margin Measure]" to the "Values" section

• Now drag the "[Measures]" field to the "Columns" section above the "Year" field

• Remove one of the measures from "Values" (e.g., remove "[Margin Measure]")

• Locate and click the "Expand all down one level in hierarchy" icon (typically appears as a downward arrow or similar icon)

• This should give you the expected result

[Cookistador]

Hi @bundipapa 

You can can achieved it by using calculation groups

 Grouping Dimension by Measures in Matrix Visual Power BI: An Illustrative Use of Calculation Groups ...