blank item in dropdown menu

[Anonymous]

hi,

lately also i'm getting an extra (Blank) line item in almost all of my slicer as per screenshots below:

[example from power bi service] 

[an example of dropdown menu in power bi service]

[example from power bi desktop]

[an example of dropdown menu in power bi desktop]

i have also found that when analyzing the data model in ms excel as follows:

[example from dropdown menu in ms excel pivot table]

[example from dropdown menu in ms excel pivot table]

i have been running this data model for few months without such case unti recently. kindly advise on how to resolve this.

tks & krgds, -nik

[amitchandak · Accepted solution]

@Anonymous , There can be few reasons behind it. Please refer to this blog for that

https://blog.crossjoin.co.uk/2019/07/10/power-bi-slicers-show-values-that-do-not-exist/

https://www.youtube.com/watch?v=23qemkDqMVY

https://exceleratorbi.com.au/rename-blank-in-a-slicer-in-power-bi/

If this does not help to fix, You can remove the blank by using visual level filter

[Anonymous]

many thanks again, @amitchandak .

i have managed to resolve the 'blank'-item in slicer as per suggested resolution in https://www.youtube.com/watch?v=23qemkDqMVY vdo.

krgds, -nik 

[amitchandak]

Thanks for Confirmation