Visual filter hands over filter to another visual when crossfiltering

[Mogry]

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, in this example the right one, to crossfilter other visuals, the other visual will be completely blank, because the filter year = 2015 is handed over to the other visual which is filterted to year = 2014.

Is this a standard behaviour or is this a bug? Is this somehow configurable?

Cheers

[V-lianl-msft]

Hi @Mogry ,

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.

[Mogry]

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.

[tex628]

I 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.

[Mogry]

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 · Accepted solution]

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