Showing results for 
Search instead for 
Did you mean: 
Post Prodigy
Post Prodigy

Slicer does not display no value option



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?



Community Support
Community Support

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.

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!

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

PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

MBAS Carousel

Sign up for our May 4th event!

May the fourth be with you, join us online!


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.