Reply
TS_PowerBI
Frequent Visitor
Partially syndicated - Outbound

Matrix with Parent Header or Grouping Measure by Type

Hello all,

 

I have 9 measures used on multiple other reports. 

I'm trying to build a Matrix and have the below results. It works but not grouped well and messy.

 MTD SalesQTR SalesYTD SalesInventorySeconday InventoryIn-TransitAt SeaFuture Orders ConfirmedFuture Orders Pending

East

         
West         
Central         

 

 

I want to have the measures have a parent title, or group them by there type (Sales, Inventory, Transit, Order). Imagine below but with merged cells. 

 

I've tired everything I can think of but falling short. Does anyone know how to do this? 

 

power.jpg

 

1 REPLY 1
hnguy71
Super User
Super User

Syndicated - Outbound

hi @TS_PowerBI 

 

It's very possible. You will need a table, likely disconnected from your model, with the 4 states AND your measure titles. Add both into your matrix as columns.

 

Next, you may need a top level measure to determine what to show. Something along this line:

 

VAR _FindMeasure = SELECTEDVALUE(DisconnectedTable[MeasureTitle])
RETURN
SWITCH( _FindMeasure,
    "MTD Sales", [MTD Sales],
    "Inventory", [Inventory],
    "Future Orders Pending", [FutureOrdersPending]
)

 



EDIT: Here's a sample set-up you'd likely need

hnguy71_0-1685199195565.png


Top-level measure:

hnguy71_1-1685199232546.png


Expected results:

hnguy71_2-1685199253413.png

 





Did I answer your question?
Please help by clicking the thumbs up button and mark my post as a solution!
avatar user

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)