Stackable Filters with Column Charts

[Anonymous]

Hi everyone.  I have multiple bar charts in Power BI that I want the user to be able to use like they were following a story.  I'm recreating something that was in Tableau but can't figure out how to do this (what seems rather simple) in power bi.  

So below, I want the user to be able to select a Location in Chart 1, then Select a date in Chart 2, Then in Chart 3 it would show all of the values from the above selected location and date so I can select a value from it.  Finally chart 4 will be the cumulative filters of all of these together.  

I've used "Edit interactions" to get what seems to be most of this but even though I tell it not to filter the other charts it still seems to filter the other charts and this locks me down to only going one route, from 1 to 4. So the user couldn't go back up and find trends from below.

So my question is, how can i get Power BI charts to not over ride each other when you are exploring/filtering?  

[Anonymous · Accepted solution]

Hi @Anonymous 

Try hitting and holding onto Ctrl before you click the next chart. e.g. select location in Chart #1, then press Ctrl and select date in Chart #2, and so on.

[Anonymous]

Yeah, someone just showed me this...  I had to do a forehead slap on this one..

but still seems kind of silly to me.  Oh well, thanks for the reply.