Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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's avatar
    Syk
    Icon for Resident Rockstar rankResident 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!

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      Perfect. Thank you!