Forum Discussion
Make Visual Ignore Drill Down From Another Visual
Hi,
I am trying to make a page with two visuals:
1) Matrix with ticket volume by Year (2022, 2023)
2) Matrix with ticket volume by Month for 2023 only
Both visuals come from the same table in my data model.
On Matrix 2) when I click the drill down arrow to expand "2023" to show Months, it is filtering Visual 1) to show only 2023.
How can I make Visual 1) Ignore the drilldown and just display 2022 and 2023 static?
Problem:
Visual 1) should remain as it appears here
I want Visual 2) to show me 2023 by month, so I click the drilldown arrow and then click on 2023 on visual 2) which gives the desired result for visual 2), except it now removes 2022 from visual 1)
My desired result would look like this:
Visual 1) 2022 and 2023, Visual 2) 2023 by Month
Click on the one you want to drill into to select it > in the ribbon, click format > Edit interactions > click the "None" button on the one you don't want it to drill on!
2 Replies
- Syk
Resident Rockstar
Click on the one you want to drill into to select it > in the ribbon, click format > Edit interactions > click the "None" button on the one you don't want it to drill on!
- AnonymousNot applicable
Perfect. Thank you!