Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Is it possible to have two charts interact if it has values instead of categories/axis.
I have two charts: One clustered column chart with 4 values and the other one is a line chart with Month on axis and same 4 values.
When I click on a value in the column chart, I would like the line chart to show only one value. Currently its not interacting.
Is there a way to do this?
Solved! Go to Solution.
Hi acbg,
The interaction/relationship between charts is based on related columns. In addtion, some chart doesn't support measure while some charts support. So if you need to use measure to filter other chart, there should be related columns.
Regards,
Jimmy Tao
Hi acbg,
Are both visuals based on same columns in your report? If they are, please click Format-> edit interactions and check if the right-top hand icon in the stacked column visual has been disabled.
Regards,
Jimmy Tao
Hi @v-yuta-msft
No they are not disabled.
I only see it working interactable if there is category.
It does not seem to work if its just column values/measures. Is that by design?
Hi acbg,
The interaction/relationship between charts is based on related columns. In addtion, some chart doesn't support measure while some charts support. So if you need to use measure to filter other chart, there should be related columns.
Regards,
Jimmy Tao
Thanks @v-yuta-msft
that was what I was afraid of as well. There is not a way for the same measures in two graphs to interact without coloumns 😞
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.