Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Anonymous
Not applicable

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

Brenden_0-1692211886698.png

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)

Brenden_1-1692211966606.png

 

My desired result would look like this:

Visual 1) 2022 and 2023, Visual 2) 2023 by Month

Brenden_2-1692212030120.png

 

1 ACCEPTED SOLUTION
Syk
Super User
Super User

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!

Syk_0-1692213240853.png

 

View solution in original post

2 REPLIES 2
Syk
Super User
Super User

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!

Syk_0-1692213240853.png

 

Anonymous
Not applicable

Perfect. Thank you!

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.