Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Solved! Go to Solution.
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!
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!
Perfect. Thank you!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
84 | |
84 | |
66 | |
62 | |
62 |
User | Count |
---|---|
199 | |
120 | |
110 | |
79 | |
69 |