Forum Discussion
Visual filter hands over filter to another visual when crossfiltering
Hi to everyone, I have two visuals. One is filtered to 2015 (right visual) and one to 2014 (left visual) on visual filter level: If you click on a product of one of theses visuals, i...
It's normal behaviour. When selecting it will take all the filters that are applied to the element and apply them to the other objects.
I think you should be able to work around it with something along the lines of this:Sales Amount 2014 = Calculate(SUM('Table'[Amount]) ; All(Calendar) ; 'Claendar'[Year] = 2014)Sales Amount 2015 = Calculate(SUM('Table'[Amount]) ; All(Calendar) ; 'Claendar'[Year] = 2015)
/ J
The visuals should be able to filter each other. If I click on a product on the right visual I want the left visual showing the same product. This is just an easy example of this behaviour which I had at a customer report and I was wondering if this is a normal behaviour or not.
tex628
Community Champion
Community ChampionIt's normal behaviour. When selecting it will take all the filters that are applied to the element and apply them to the other objects.
I think you should be able to work around it with something along the lines of this:
Sales Amount 2014 = Calculate(SUM('Table'[Amount]) ; All(Calendar) ; 'Claendar'[Year] = 2014)Sales Amount 2015 = Calculate(SUM('Table'[Amount]) ; All(Calendar) ; 'Claendar'[Year] = 2015)
/ J