Forum Discussion
Visual filter hands over filter to another visual when crossfiltering
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
Community ChampionI think you can solve this by editing interaction between the two tables:
Select a visual and then click "None" on the other:
Do this on both.
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
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