cancel
Showing results for 
Search instead for 
Did you mean: 
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
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.