Slicer showing blank as option

[Shivarajeshwari]

I have added location in slicer, It is showing blank option. When I clicked the blank option it is showing some other data, ex: I am selecting Noida, actually I have 3 sites in Noida location, one site is missing which is linked with blank option. All the data from source are looking good. Please help me with this.

Thank you in advance 

[v-luwang-msft]

Hi @Shivarajeshwari ,

Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.

Best Regards
Lucien

[PhilipTreacy]

Hi @Shivarajeshwari 

Without seeing your file it's hard to assist.  Your original question was about removing the blank option from a slicer - this I gave you a solution for.  But you say that you have already done that.  So I'm unclear as to what exactly your issue is because I don't understand your data 

Please provide your PBIX file so I can take a look and understand better.

Regards

Phil

[PhilipTreacy]

Hi @Shivarajeshwari 

I'm not sure if you want to keep those blanks, I can't tell without seeing your data and knowing more, but one approach would be to place a filter on the slicer to not show blanks.

For example, here's a slicer with a blank option, notice the filter is set to show everything

By unticking the blank in the slicer filter, it is removed from the available options in the slicer

regards

Phil

[Shivarajeshwari]

Hi @PhilipTreacy  Thank you for your response, This solution I have done. But the data is linked with the blank option, is of another Data of others site which I want to display. So I am confused, any other solution to replace the blank with required site