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
Hi Anonymous ,
As tex628 said before, You can try to cancel visual filter and create a calculated column or measure to display the sales volume of each year
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you both for your answers. I was looking for an answer if this is a standard behaviour or a bug and if this is somehow configurable, because none of my team was aware of this behaviour. Canceling the crossfiltering between visuals wasn´t an option. The solutuion in the customer report, not this sample from the november update report, was indeed using measures to satisfy the customer needs.