Slicer does not display no value option

[UsePowerBI]

Hello

I am bringing columns from different tables into a table visual. I have applied a page filter on one column and I have also selected to show items with no data.

I bring one of the above columns into a slicer visual. It shows the values available in the column of the table visual but it does not show the option of no-value when there are fields in the table visual that have no value.

Can you advise please how to fix that?

Thanks

[v-lionel-msft]

Hi @UsePowerBI ,

Like this?

Maybe your filter has filtered out this value in the slicer.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@UsePowerBI , slicer should show blank value in the slicer.

In case you want to replace blank with something, then try

new column = coalesce([column],"No Value")

[vanessafvg]

if there is no value, it will have nothing to show, you will need to create a value called no value, ie. if(isblank(fieldname), "no value", fieldname)