Don't miss your chance to take the Fabric Data Engineer (DP-700) exam on us!
Learn moreThe FabCon + SQLCon recap series starts April 14th at 8am Pacific. If you’re tracking where AI is going inside Fabric, this first session is a can't miss. Register now
Hi! I want to create a visualisation where interacting with the line chart alters the pieie chart so it shows the shares between categories for the selected year. This is the current report:
Interacting with the line chart produces this:
Which shows the share of the selected year relative to the total - which I do not want.
I have tried using drill down pie charts by zoom charts, with no luck.
Any ideas?
In advance, thank you so much!
Solved! Go to Solution.
By default with some visuals, the behavior is cross-highlighting, not cross filtering. However, you can change the cross-highlighting to be cross-filtering. Change how visuals interact in a report - Power BI | Microsoft Learn
Proud to be a Super User! | |
Thank you! Worked perfectly!
Disable the Interaction between both Pie chart and line chart by using Edit Interactions .
Select the chart ->Go to Format --> Edit Interactions.
By default with some visuals, the behavior is cross-highlighting, not cross filtering. However, you can change the cross-highlighting to be cross-filtering. Change how visuals interact in a report - Power BI | Microsoft Learn
Proud to be a Super User! | |
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 53 | |
| 40 | |
| 38 | |
| 19 | |
| 18 |
| User | Count |
|---|---|
| 70 | |
| 69 | |
| 34 | |
| 33 | |
| 30 |