How to Hide fields in matrix table if no selection in field parameters

[PradeepSpowerbi]

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 

[v-karpurapud · Accepted solution]

Hi @PradeepSpowerbi 

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.

[v-karpurapud]

Hi @PradeepSpowerbi 

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

[PradeepSpowerbi]

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 

[Aala_Ali]

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 Group

linked in profile: https://www.linkedin.com/in/aala-ali/

[PradeepSpowerbi]

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 

[Aala_Ali]

Okay i got you, so the reason is that your table shows no data when you select None is because the parameter is returning a BLANK() value.

A blank value removes all rows in a table visual.

To fix this, we just need “None” to return an empty text column instead of a blank measure. That way:

The View By column becomes empty

But all your other columns still show normally

Here’s the exact DAX to use:

 1. Create a helper table with an empty text column

HelperNone =
ADDCOLUMNS(
{ (1) },
"NoAttribute", ""
)

This creates a column NoAttribute that always returns an empty string.

 2. Update your field parameter to include the new “None” option
Replace your parameter table with this version (change YourTable to your real table name):

Attributes = {
("DRIVER ID", NAMEOF('YourTable'[Driver ID]), 0),
("DRIVER NAME", NAMEOF('YourTable'[Driver Name]), 1),
("LEADER NAME", NAMEOF('YourTable'[Leader Name]), 2),

// Updated "None" option
("None", NAMEOF('HelperNone'[NoAttribute]), 3)
}

 Result
Matrix → selecting “None” hides everything

Table → selecting “None” keeps the table visible and only empties the “View By” column

I hope this works for you 👌  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/

[Aala_Ali]

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-Selec...

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/