Forum Discussion
Dynamic category for chart axis and perform drill through as well as cross filter.
Hi Need some help/suggestion on below issue. I've dataset which contains 10-20 Category depend upon customer and sample data look like as below. Where I've different catagory(10-20) in col., C...
amitchandak
Super User
Super Userdheer1610 , I think interactions can help . Right top only interact with Right bottom. Right bottom with Left bottom, Left bottom with left top, Based on what I got.
Change interactions and try https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions
How Interactions Work- Split Page using interactions to compare: https://youtu.be/GIfRKzhMaR4
amitchandak same I implemented too.
Catagory1 drop down only controlling Chart1.
Catagory2 drop down only controlling Chart2.
Catagory3 drop down only controlling Chart3.
But the challenge is select any bar in any chart it's not filtering/highlighting the impact on other charts. It's showing zero as result in other charts.