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
iooab1-
Frequent Visitor

Slicer on multiple boolean columns

I'm following this post.

 

https://community.powerbi.com/t5/Desktop/Filter-Table-based-on-multiple-True-False-columns/m-p/65461...

 

The slicer works on the table but the chart doesn't seem to like what I did and only shows 1 datapoint.

 

https://app.box.com/s/4tyz6p5jzo548m84aimy4ajp33e1fgpb

2 REPLIES 2
lbendlin
Super User
Super User

Thank you for providing the sample data. You have a single directional 1:M relationship from Date to Table3. That means your Date table doesn't care if anything changes in the filters of Table3.

 

You can make the relationship bidirectional to allow the filters to flow, but that should be done with great care.

 

lbendlin_0-1639617175614.png

 

 

I played around with these settings and did not get a different result in the line chart.

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.