Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
Anonymous
Not applicable

How to display/group similar measures in columns?

Hi,

 

I have several different reports. In each of them I have different measures but regarding the same period of time:

CY, PY, CY YTD, CY YTD, CY YTG vs PY %.

I would like to keep them in one clean Matrix (?) table, having above periods in columns, and measure names in rows.


Is there any way to do it on visuals?

 

Value3.png

 

2 REPLIES 2
amitchandak
Super User
Super User

@Anonymous , you have created a table like this and use that for display. Any filter you need need to added to this table

 

Summarize table for formatted tables

Display Table = union (SUMMARIZE(Sales," Measure", "MTD", "This",[MTD],"Last",[LMTD],"Change",[MOM]),
SUMMARIZE(Sales," Measure", "QTD", "This",[QTD],"Last",[LQTD],"Change",[QOQ]),
SUMMARIZE(Sales," Measure", "YTD", "This",[YTD],"Last",[LYTD],"Change",[YOY]))

 

Table 2 = union (SUMMARIZE(Sales,'Item'[Category]," Measure", "MTD", "This",[MTD],"Last",[LMTD],"Change",[MOM]),
	SUMMARIZE(Sales,'Item'[Category]," Measure", "QTD", "This",[QTD],"Last",[LQTD],"Change",[QOQ]),
	SUMMARIZE(Sales,'Item'[Category]," Measure", "YTD", "This",[YTD],"Last",[LYTD],"Change",[YOY]))

 

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
Fowmy
Super User
Super User

Hi,

Use a disconnected table approach, it should work.

Refer to this article on how to do it: https://exceleratorbi.com.au/measures-on-rows-here-is-how-i-did-it/

 

Did I answer your question? Mark my post as a solution!

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.