cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper I
Helper I

Why is (Blank) still showing up in my Slicer when I've applied a visual-level filter?

Slicer still showing Blank.PNG

7 REPLIES 7
Community Support
Community Support

Hi @s-turn ,

 

How about the result after you follow the suggestions mentioned in my original post?

Could you please provide more details or expected result about it If it doesn't meet your requirement?

If you've fixed the issue on your own please kindly share your solution. If the above posts help, please kindly mark it as a solution to help others find it more quickly.

 

Best regards,

 

Community Support Team _ zhenbw

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

Community Support
Community Support

Hi @s-turn ,

 

Please double check there is no blank in your True or False column.

If there is no blank, maybe the relationship causes the issue.

For example, Table and Table (2) have an one-to-many relationship based on Name.

 

w1.jpg

 

But the Name does not exactly match.

 

w2.jpg

 

w3.jpg

 

If it doesn’t meet your requirement, could you please provide a mockup sample based on fake data or describe the fields of each tables and the relations between tables simply?

It will be helpful if you can show us the exact expected result based on the tables.

 

Please upload your files to OneDrive For Business and share the link here. Please don't contain any Confidential Information or Real data in your reply.

 

Best regards,

 

Community Support Team _ zhenbw

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

Helper I
Helper I

@amitchandak  thank you for your quick reply!  IThe underlying data is not changing, and there are no blank values in the columns that the slicers refer to - only True or False.  The slicers and the measure in the bar chart they act upon are all from the same table.  However, that table includes some calculated columns that refer to data from related tables (this table being at the centre of a simple star schema), so I am wondering if it is something to do with that.  I've gone through the different relationships trying to figure out what it could be, but nothing has worked.  

Super User II
Super User II

@s-turn 

 

It shouldnt be doing that. Restart PowerBI and exclude blanks again. Or check if the issue still exists in a separate page.

 

Last option is to select 'Advance Filtering' and select 'is not blank' value

Thank you - I've just restarted Power BI and it hasn't made a difference. When I try on a new page, I still get (Blank) showing up in the Slicer. I don't seem to have an option to use Advanced Filtering - only Basic and Top N:

No option for Advanced Filtering.PNG

@s-turn 

 

Can you share the workbook with us to have a look at it? Mask any confidential data

Super User IV
Super User IV

@s-turn , There can few reasons, refer to this blog

https://blog.crossjoin.co.uk/2019/07/10/power-bi-slicers-show-values-that-do-not-exist/

or video

https://www.youtube.com/watch?v=23qemkDqMVY



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!

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Wave Release 2

Check out the updates in Power BI.

Overview of Power BI 2020 release wave 2!

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

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