select columns with a preselected slicer to display them as columns in a table

[EricLetourneur_]

In Power BI , I want to have slicers with pre selected items on it.

I use a visual called Preselected Slicer from Insiders.coop.

I put a dynamic field parameter in the Fields of this preselected slicer.

And finally I put the dynamic field parameter in the columns of  a table for the user.

So when one column is selected in the preselected slicer, I have only one column in this dynamic table.

But I encounter an issue when no item are selected in the preselected slicer, 

all columns appear in the result table. I would like no column in the table in this case.

[Shahid12523]

Problem: When no column is selected in the Preselected Slicer, your table shows all columns—but you want it to show none.
Fix: Create a DAX measure like this

IsFieldSelected = IF(HASONEVALUE('Field Parameter Table'[Field]), TRUE(), FALSE())

Then apply it as a visual-level filter on the table: show the table only when IsFieldSelected = TRUE.

[VahidDM]

In Power BI, field parameters always show all fields when no slicer value is selected — that’s the default design. That’s why in your case, when nothing is chosen in the Preselected Slicer, your table shows every column.

To work around this and show no columns instead of all, you can:

1. Add a dummy field to your field parameter (e.g., "Blank" with an empty measure).

2. In your Preselected Slicer, set "Blank" as the default selected value.

3. Adjust your table so that when "Blank" is selected, it only shows that empty column.
   → Result: no real columns are displayed until the user makes a choice.

That way, if nothing is selected (or if "Blank" is the default), your table won’t show unintended columns.

[pankajnamekar25]

Hello @EricLetourneur_ 

when using a field parameter with a preselected slicer, the default behavior is that if no item is selected, all fields appear in the table. To avoid this, you can add a dummy column into your field parameter. The dummy column can either display a static message like “No column selected” or simply return BLANK(), which makes the table look empty. By including this dummy option in the parameter and setting it as the fallback, the table will show only the dummy column instead of expanding with all fields whenever the slicer has no selection

If my response helped you, please consider clicking
Accept as Solution ✅ and giving it a Like 👍 – it helps others in the community too.


Thanks,


Connect with me on:

LinkedIn

[EricLetourneur_]

thank you for your answer.
Can we force the selection of this dummy column when no column is selected in the pre selected slicer ?
I think no...

[pankajnamekar25 · Accepted solution]

@EricLetourneur_ 

You’re right by default you cannot force a field parameter slicer to fall back automatically to one item (like a dummy column) when the user clears all selections.

If my response helped you, please consider clicking
Accept as Solution ✅ and giving it a Like 👍 – it helps others in the community too.


Thanks,


Connect with me on:

LinkedIn