Forum Discussion
Field Parameters nothing selected, show blank on a visual
Hi Anonymous ,
Referring to this document, the field parameters have certain restrictions:
- There's no way for your report users to select the "none" or no fields option. Selecting no fields in the slicer or filter card is the same as selecting all fields.
You can post your idea to Ideas . https://ideas.powerbi.com/ideas/
You can refer to the following posts for solutions to use slicers instead:
Solved: Dynamic Table Columns With Slicer Using Field Para... - Microsoft Power BI Community
Solved: Show blank when nothing is selected in the slicers - Microsoft Power BI Community
Solved: Visual blank until filter selected - Microsoft Power BI Community
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Advocate IHi all,
To display a complately empty table
1. Create a measure: Blank measure = Blank()
2. Add blank measure to your field parameter under option "None" ie
Clever trick is to cover the "none" option so user cant see it in the slicer and have a bookmark & button to "Clear field selection" or something like that
I've put " " instead of "None" and when I select that option the column disappears. Thanks! 😄
