- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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 Sales | QTR Sales | YTD Sales | Inventory | Seconday Inventory | In-Transit | At Sea | Future Orders Confirmed | Future 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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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
Top-level measure:
Expected results:
Did I answer your question?
Please help by clicking the thumbs up button and mark my post as a solution!

Helpful resources
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.
Power BI Monthly Update - June 2025
Check out the June 2025 Power BI update to learn about new features.

Subject | Author | Posted | |
---|---|---|---|
Anonymous
| 06-23-2022 08:20 AM | ||
05-23-2025 12:56 AM | |||
03-27-2025 07:19 AM | |||
04-04-2025 11:35 PM | |||
06-06-2025 05:23 AM |
User | Count |
---|---|
67 | |
58 | |
50 | |
36 | |
34 |
User | Count |
---|---|
84 | |
73 | |
58 | |
45 | |
44 |