Reply
twebb
Frequent Visitor
Partially syndicated - Outbound

Grouped Measure Field Parameters Not Working

Hello! I'm stumped and hoping someone here is smarter than I am!

I created a field parameter with 6 measures and added a 'Group' column that identifies them as either 'Actual' or 'Forecast' measures. I'd like to use the 'Group' as a column header in a matrix, so you'd see the 'actual' measures under 'Actual' and the 'forecast' measures under 'Forecast'. However, when I move Group into the column headers, I get all 6 measures under each group and I can't figure out why. If I select one of the groups from a slicer, it works as expected and only shows the 3 measures in that group. If I don't select anything, it shows all 6 under each group.

Parameter

twebb_5-1724870157306.png

 

 

Matrix (Current State)

My matrix looks like this but I'd expect only the red columns to be visible under 'Actual/Backlog' and only the blue to be visible under 'Plan/Forecast'. As of right now, they are all showing up under both.

twebb_3-1724869938294.png

Matrix (Expected)

I just made the columns narrow here to show what it should theoretically look like.

twebb_4-1724870072617.png

Here is how I have the matrix set up.

twebb_6-1724870250875.png

 

Any information would be extremely helpful 😁

 

Thanks

1 REPLY 1
v-xingshen-msft
Community Support
Community Support

Syndicated - Outbound

Hi @twebb ,

Can you provide the relevant pbix file or some example data, this will help to help you solve the problem better, if you don't know how to upload, please refer to the following link:
How to provide sample data in the Power BI Forum - Microsoft Fabric Community
Hope it helps!

Best regards,
Community Support Team_ Tom Shen

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

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

March2025 Carousel

Fabric Community Update - March 2025

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

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