Charts as Slicer or multiple cross-filtering

[vickyd]

This idea Charts as Slicers shows up as completed but the functionality isn't there in Power BI currently i.e. ability for Charts to function as Slicers so that one can click on say a bar on the first chart and then say click on another bar on a 2nd chart and the whole report is filtered by those 2. 

e.g. I have a quarterly Cost chart and another Accounts-wise cost chart and a third category wise cost chart. 

1. I see that Q2 costs are significantly higher so click on Q2 in the quarterly chart

2. I find that a certain Account had significantly high costs

3. I then want to click on the Account to find what category of costs the Account had in Q2.

Currently, the moment I click on Account, the quarterly filter is gone! 

How can one even analyze without such a feature? Almost feel like this should be one of the most voted ideas! 

Is there any workaround/alternative to achieve this other then adding slicers?

[v-huizhn-msft]

Hi @vickyd,

The chart used in slicer is not the one you created. It is one field from your resouce table. You can store image URL in source table, please see the following sample table.

Then create a Chiclet Slicer, select the URL as image, you will get the expected result.



For your three chart, they must created by using different table, right? If it is, if there any common columns between the tables, you can create relationship between them. So the charts will affect each other. If it is, could you please share more details or your sample table for further analysis?

Best Regards,
Angelia

[vickyd · Accepted solution]

I think you may have understood it wrong. What I'm talking about is multiple cross-filtering. 

Just found an idea asking pretty much the same thing and looks like it has garnered a lot of votes. Hope it gets done quickly as without it 1/2 of the value of the product is lost from an analysis perpective. 

[Anonymous]

I think we can achieve this by  'Ctrl+click' on the bar...instead of just click on the bar

[v-huizhn-msft]

Hi @vickyd,

Got it. I am gald you find the idea by yourself. Please mark your helpful reply as answer, so more people will find solution easily. Power BI will become better because of your support.

Best Regards,
Angelia