cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
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.

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

Announcements
secondImage

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

secondImage

Power BI Women

Join our monthly meetings and learning sessions.

secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

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.

Top Solution Authors
Top Kudoed Authors