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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
baludo
Frequent Visitor

Hide a value from a Slicer without filtering

Hello,

 

I have two tables connected via a Many to one (*:1) relationship.

On the Many-table there a value that doesn't match the One-Table, this causes a (blank) value to show up.

 

 

Example with (Blank) Value:

 1.png

 

 

I understand that I can use the page level filter or a different slicer to filter out the (blank)

2.png3.png 

 

My problem is that I need to hide (blank) without making the values on Table1 to be filtered out.

Anyone has any ideas?

 

Thanks advance!

1 ACCEPTED SOLUTION
Anonymous
Not applicable
1 REPLY 1
Anonymous
Not applicable

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.