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
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!

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.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.