cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
UsePowerBI
Post Prodigy
Post Prodigy

Slicer does not display no value option

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

3 REPLIES 3
v-lionel-msft
Community Support
Community Support

Hi @UsePowerBI ,

 

Like this?

v-lionel-msft_0-1596163411678.png

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
Super User IV
Super User IV

@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")



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

vanessafvg
Super User I
Super User I

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)




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
User Groups Public Preview

Join us for our User Group Public Preview!

Power BI User Groups are coming! Make sure you’re among the first to know when user groups go live for public preview.

March Update

Check it Out!

Click here to read more about the March 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.