Forum Discussion
Interactive Drill Down Visual Dashboard
If I am understanding your question correctly I beleive this is possible through Edit Interactions options.
- First click the Edit Interactions button in the Home ribbon.
- Then click on the region visualization like shown in your firs picture.
- Then change interaction between region and subcateogry from Highlight to Filtered. This is done by clicking on the filter icon in the top right of the subcategory visualization. I put a red arrow next to where to do this in the picture below.
- Now when a region is highlighted it should drill into the subcategory and show the filtered version of the donut chart instead of the highlighted version.
Let me know if this is what you are trying to accomplish!
Hi Twan,
Thank you for the reply, I have tried edit interactions, but when I clik on sales category view to filter sales sub-category.Its not filtering based on the filtered region in the sales category, its filtering by all regions in the sales category.
Thank you
Regards, Anil Kumar.
I think what you are trying to do is not possible right now with Power BI. Normally you could do something like ctrl + clicking different charts to cross filter each of the different charts based on what you clicked. Here is an ideas post you can upvote that would add that functionality.
What could work for now is if you put slicers on the canvas for Region, Category and Subcategory. Then use the slicers for cross filtering instead of clicking on the charts.
Help me , how to attach Power BI report?