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

Date Range on multiple filters for specific visuals on same page for comparison

Sorry for the crappy title, couldnt come up with a better one.

 

Scenerio: 

- same table

-I have created a DATE1 and DATE2 column based off of the DATE column

-4 visuals - 2 matrix - 2 line charts

 

What I want to do is:

- DATE1 filter to control Matrix1 LineChart1

- DATE2 filter to control Matrix2 LineChart2

 

What I am trying to do is have the page split so I can compare 2 different date ranges on the same page from the same column.

 

I know I can make a duplicate table refrencing the original, but the data set is getting big and it will only bog it down and make the data set bigger.  I was hoping I could group the visuals together to have a filter control specific visuals instead of the whole page.

 

Is there a way to do this?

example.PNG

1 ACCEPTED SOLUTION
rsbin
Impactful Individual
Impactful Individual

@rjs2,

Select your first slicer.  Select the Format Menu and Select Edit Interactions.

rsbin_0-1638545796257.png

 

Then you can turn off the Interactions on those visuals that should not be affected.  (circle with the line thru it)

rsbin_1-1638545831256.png

This should do it for you.

Regards,

View solution in original post

3 REPLIES 3
rsbin
Impactful Individual
Impactful Individual

@rjs2,

Select your first slicer.  Select the Format Menu and Select Edit Interactions.

rsbin_0-1638545796257.png

 

Then you can turn off the Interactions on those visuals that should not be affected.  (circle with the line thru it)

rsbin_1-1638545831256.png

This should do it for you.

Regards,

View solution in original post

Thanks!  I totally forgot about that! grrrr lol - but thank you for jarring my memory!

rsbin
Impactful Individual
Impactful Individual

@rjs2,

Happy I could help.

 

//  Kudos are always appreciated on the Board when questions are resolved.

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors