Forum Discussion
How to Hide fields in matrix table if no selection in field parameters
- 8 months ago
We have not received a response from you regarding the query and were following up to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.
Thank You.
Hi PradeepSpowerbi,
You’re doing everything correctly — it’s Power BI behavior that’s causing the issue.
Field parameters never treat “no selection” as zero fields. They automatically fall back to “select all”.
To hide the matrix, you must add a dedicated “None” option or build a custom selector.
1. Add a “None” option to the field parameterCreate a blank measure like this:
Nothing Selected = BLANK()
Edit your field parameter table and add a new line:
("None", NAMEOF('Measures'[Nothing Selected]), 3)
Turn OFF Show items with no data in the matrix.
How it works:
When the user selects Driver ID, Driver Name, Leader Name → everything works normally.
When the user selects None, the matrix receives only BLANK values, so it “disappears”.
2. Build your own selector (more work, more control)
If you really want the visual to hide when literally nothing is selected, you’ll need to stop using field parameters and instead create a disconnected table + SWITCH measure.
This method allows:
User selects 1 field → show it
User selects nothing → return BLANK → matrix hides
But it requires more DAX and manual setup. Field parameters cannot do this on their own.
Here is the similar issue to yours you can go through it:
https://community.fabric.microsoft.com/t5/Desktop/Hide-Slicer-Content-based-on-Field-parameter-Selection/m-p/4855993
If this helps please ✔ Give a Kudo • Mark as Solution – help others too!
Aala Ali
Pricing & Profitability Specialist | Data Analyst at Zain Telecom
Group Leader – Microsoft Sudan Fabric User Group
linked in profile: https://www.linkedin.com/in/aala-ali/