Forum Discussion
Field Parameter Expand/Collapse for Matrix visualization
Hi Jihwan_Kim ,
As per your question, this is an expected behaviour with respect to field Parameter introduced with the GA release of field parameters as of July 2025.
Previously, if using a field parameter in an expanded matrix and switching the dimension or measuring the parameter selected, the matrix would collapse. Starting this month, efforts have been made to keep the matrix in the same state as possible.
Refer- https://powerbi.microsoft.com/en-us/blog/power-bi-july-2025-feature-summary/#post-30545-_Toc203388693
Hope this helps!
Hey InfoMagician,
Great question!
You're right to be curious about this - it's not a straightforward built-in function, but rather a combination of techniques that can achieve the desired behavior.
Solution 1: Measure: -
Current Parameter Selection =
VAR CurrentParam = SELECTEDVALUE('Field Parameter'[Field Parameter Fields])
RETURN CurrentParam
Dynamic Display Measure =
VAR CurrentParam = SELECTEDVALUE('Field Parameter'[Field Parameter Fields])
VAR IsCountrySelected = CurrentParam = "Country"
VAR IsUnitSelected = CurrentParam = "Unit"
RETURN
SWITCH(
TRUE(),
IsCountrySelected, [Country Level Measure],
IsUnitSelected, [Unit Level Measure],
BLANK()
)
Solution 2: Modified Matrix: -
Dynamic Hierarchy =
VAR SelectedParam = SELECTEDVALUE('Field Parameter'[Field Parameter Fields])
VAR CountryName = SELECTEDVALUE(Geography[Country])
VAR UnitName = SELECTEDVALUE(Units[Unit])
RETURN
SWITCH(
SelectedParam,
"Country", CountryName,
"Unit", UnitName,
BLANK()
)
Start with Solution 2 (Modified Matrix Setup) as it's the most reliable and doesn't depend on drill state behavior. It gives you clean control over what displays when each parameter is selected.
Fixed? ✓ Mark it • Share it • Help others!
Best Regards,
Jainesh Poojara | Power BI Developer
Hi,
Thank you for your suggestion, but I keep failing to implement it. 😥
If it is OK with you, it will be very much helpful if you can describe how to implement it by sharing the link of the sample file or screen shots. It will be very much appreciated, and it will save my tons of time to fix this.
Thank you.
Hey Jihwan_Kim,
Sure, will share the .pbix file in a while.
Best Regards,
Jainesh Poojara | Power BI Developer