cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
QC
Kudo Commander
Kudo Commander

PBI Matrix Visual: how to put measure/value/metric above column header?

Hi team, 

Is there a way to put measure names above column header like in Excel?

For example, in a matrix visual, I have 2 measures (Sales, Budget) in value, Year/Quarter in column. PBI stacks both measures under the same QTR, it is very hard to read.

I know in Excel pivot table, if there are multiple measures, you can move it to the 1st order on columns. Just wonder if PBI can do the same. 

Capture.JPG

I am using PBI Desktop December 2022 version ... thanks!

1 ACCEPTED SOLUTION
QC
Kudo Commander
Kudo Commander

I figured it out! I created a calculated group with 2 measures (Amount, VPY), added it to Matrix column header, it worked 😄 

 

Capture.JPG

 

View solution in original post

1 REPLY 1
QC
Kudo Commander
Kudo Commander

I figured it out! I created a calculated group with 2 measures (Amount, VPY), added it to Matrix column header, it worked 😄 

 

Capture.JPG

 

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors