Forum Discussion
How to Hide fields in matrix table if no selection in field parameters
Hi ,
I have a matrix table with columns Calendar event , Start date as columns and count of names as measures .
now i have created a field parameter list with FIELD NAME - attributes and values as DRIVER ID , DRIVER NAME , LEADER NAME .
In matrix table , i have added ATTRIBUTES in the table as row and when i select values from that field it is reflecting in the matrix and there are no issues . But if i dont select anything , it should be hidden but it is not hiding . How to achieve this
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.
7 Replies
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/4855993If 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 Grouplinked in profile: https://www.linkedin.com/in/aala-ali/
Hello ,
Thank you for the response . I will go with first option. I do have one more query . Is there a possibility to expand all rows automatically based on selection of field parameters or by default . I see that every time I need to right click on the data -->expand --> ALL . I need an alternative for this
Hi again,
Glad the first option works!
About auto-expanding all rows in the matrix:
Power BI doesn’t currently support automatic expand-all, and field parameters don’t trigger expansion either. Each time the parameter changes, the matrix resets to the default collapsed view.What you can do:
Manually expand once and save a bookmark (but it won’t auto-expand when the selection changes).Use a Table visual instead of a Matrix if you don’t need hierarchy.
Or redesign the rows to avoid multiple levels.
Unfortunately, there’s no true “auto expand all” option in Power BI at the moment — it’s a product limitation.
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 Grouplinked in profile: https://www.linkedin.com/in/aala-ali/
okay . I have a table VIEW BY ATTRIBUTES COLUMNS along with other direct columns . I am trying to create a table but when I select none in parameters , the table is showing no data . It should show the data for other fields . How to achieve it
I would also like to thank you Aala_Ali for your active participation and for sharing solutions within the community forum.
I hope the information provided helps resolve your issue. If you have any further questions or need additional assistance, please feel free to contact us. We are always here to help.
Best regards,
Community Support Team
