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
Super User
Super User

@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
Super User
Super User

@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,

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

@rjs2,

Happy I could help.

 

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

Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!