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
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 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.