Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
DataNinja777
Super User
Super User

Removing blanks from Slicers (New)

Hi Power BI Community,

 

I'd like to remove the blanks from the Slicers (New).  Please could you let me know how I can get rid of the blanks from the slicers below?  I made sure that the calendar table and the related fact tables do not have the data which are not covered by the calendar table, but blank still appears and I cannot get rid of them.  

Thank you.  

DataNinja777_0-1702863383662.png

 

2 ACCEPTED SOLUTIONS
amitchandak
Super User
Super User

@DataNinja777 , Use a visual level filter to remove the blank value,

The month is not blank or the date is not blank

 

For reasons check - https://www.youtube.com/watch?v=23qemkDqMVY

View solution in original post

Ritaf1983
Super User
Super User

Hi @DataNinja777 

Please refer to the linked videos:

https://www.youtube.com/watch?v=3hI3CP_nv_4

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

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

View solution in original post

2 REPLIES 2
Ritaf1983
Super User
Super User

Hi @DataNinja777 

Please refer to the linked videos:

https://www.youtube.com/watch?v=3hI3CP_nv_4

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

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

amitchandak
Super User
Super User

@DataNinja777 , Use a visual level filter to remove the blank value,

The month is not blank or the date is not blank

 

For reasons check - https://www.youtube.com/watch?v=23qemkDqMVY

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.