Field Parameter grouping breaks in Matrix visual

[BM4291]

Hi,

Having some difficulty with using a Field Parameter in a matrix; it looks like there are some similar issues out there so this one is possibly a bug, or I'm missing something obvious.

Example data used due to confidentiality; hopefully makes sense from a high-level.

I have the below field parameter:

{
	("Measure 1", NAMEOF(MasterQuery[M_Measure1]), 1, "Headline", "Section 1")
	, ("Measure 2", NAMEOF(MasterQuery[M_Measure2]), 1, "Headline", "Section 1")
	, ("Measure 3", NAMEOF(MasterQuery[M_Measure3]), 1, "Change", "Section 2")
	, ("Measure 4", NAMEOF(MasterQuery[M_Measure4]), 1, "Headline", "Section 3")
}

When I add this to a matrix, I want to group my values by the 4th column (Section 1/2/3), but what happens is, the grouping doesn't apply, and all measures show under all headers. I've tried to illustrate this below where you can see the behaviour vs. the expected:

I've also tried creating a dimension table based on the unique values and using that in a relationship but it returns the same behaviour which seems even more odd.

If I filter by the column this works as expected which is why I'm suspecting a bug.

Anyone else encounter this/have any suggestions?

[BM4291]

@Idrissshatila thanks for the reply; the data in this specific report is largely flat, so the area values are coming from the 'MasterQuery' table.

[Idrissshatila]

@BM4291 ,

so if you didn't find a solution and you suspect it is a bug you could reach out to microsoft support and they can assist https://support.powerbi.com

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote For my Idea💡

[Idrissshatila]

Hello @BM4291 ,

make sure there's an active relationship between the area table and the masterQuery table.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote For my Idea💡