cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
QC
Advocate III
Advocate III

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
Advocate III
Advocate III

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
Advocate III
Advocate III

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
Winner of T-Shirt Design

Power BI T-Shirt Design Challenge 2023

Find out who won the T-Shirt Design Challenge and the top 3 finalists.

March 2023 Update3

Power BI March 2023 Update

Find out more about the March 2023 update.