Interactive Drill Down Visual Dashboard

[anil]

Hi all,

         I am trying to build an interactive dashboard, but facing an issue. I have three  views in the dashboard as shown below,

when I click on region, the remaining views are getting effected, but when I am selecting the filted part of the region in the sales by category view, its going back to the whole views insted of the filted view by region.

What I need is the drill down view of the filterd sales category by region, to be shown in the sub category view.

Is it possible to do so? If its is please help me out.

[Twan]

If I am understanding your question correctly I beleive this is possible through Edit Interactions options.

1. First click the Edit Interactions button in the Home ribbon.
   1. 
2. Then click on the region visualization like shown in your firs picture.  
3. 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.
   1. 
4. 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!

[calerof]

When you are in Edit Interactions, you are no longer in the dashboard, right? The problem I'm facing too is that the drill down functionality is not enabled in the dashboard.

[anil]

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.

[Twan]

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.

[anil]

Help me , how to attach Power BI report?