Forum Discussion
Field parameter not fully updating table/matrix table
- 1 year ago
Hi mlim0806,
Thank you for reaching out.
We understand that you are experiencing an issue where a field parameter created in Power BI is not filtering the table or matrix visual as expected. Specifically, when a selection like “Group A” is made using the parameter slicer, the visual continues to display data for all groups instead of only the selected one. This behaviour occurs because field parameters in Power BI are designed primarily for dynamically switching between columns or measures in a visual, not for filtering row-level data.
To achieve the expected filtering effect, we recommend using a regular slicer that directly references the data column.
For instance, using the Group column from your dataset in a slicer visual. Once this slicer is added to your report and a group is selected, the table visual will automatically filter to show only the rows corresponding to that selection, such as only records for “Group A.” This method ensures that the visual reflects the correct subset of data based on user input. Field parameters remain useful for dynamic content switching in visuals, but are not suitable for applying data filters at the row level.
Additionally, I have included the PBIX file that I created using the provided sample data. Kindly review it and confirm whether it aligns with your expectations.Happy to help! If this addressed your concern, marking it as "Accepted Solution" and giving us "kudos" would be valuable for others in the community.
Than you.
Hello mlim0806
Create measure
Show Selected Group =
SWITCH(
SELECTEDVALUE('Field Parameter Table'[Name]),
"Group A", IF(MAX('Data'[Group]) = "Group A", 1, 0),
"Group B", IF(MAX('Data'[Group]) = "Group B", 1, 0),
"Group C", IF(MAX('Data'[Group]) = "Group C", 1, 0),
1
)
Thanks,
Pankaj Namekar | LinkedIn
If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.
Hi Pankaj,
can you clarify what values go here "'Data'[Group]"? Is it my table where I created the field parameter?