To setup a slicer to have BLANK() value as default

[mpataki32]

I have a page and it requires to have a blank value for the slicer, how should I do it? 

[selimovd · Accepted solution]

Hey @mpataki32 ,

the easiest way is if you add a blank row to your column that you want to use for the slicer. Usually that should be at the dimensional table.

Would that work?

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards
Denis

Blog: WhatTheFact.bi
Follow me: twitter.com/DenSelimovic

[mpataki32]

Hi @selimovd, 

The thing is that I don't really want to manipulate data, the reason why I need this, because I have 1000+ vendors and heavy calculations (sadly it was a business request) and I want to force the users to select their own items, with the BLANKS() I want to prevent Power BI to start calculate the things and populate information for all items. 

[selimovd]

Hey @mpataki32 ,

sure, I understand that. But as far as I know there is no possibility to add a blank or dummy item to the dimension slicer without adding it to the table (either with Power Query or DAX).

So I guess if you want that, then there is no other way than to add a dummy row to the table.

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards
Denis

Blog: WhatTheFact.bi
Follow me: twitter.com/DenSelimovic

[mpataki32]

Hi @selimovd, 

So the final solution what I am going to implement is to create a technical table in my report and then append its records with my base table. Of course there would be other solutions as well and I am not 100% comfortable with the solution, but sometimes we need to accept that there are some limitations. 

Thank you you helped me a lot! ( - :