cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Mogry
Advocate I
Advocate I

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:

 
 

1.png

 

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.

 

2.png

 

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

 

Cheers

1 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


Connect on LinkedIn

View solution in original post

5 REPLIES 5
V-lianl-msft
Community Support
Community Support

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.

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
Super User
Super User

I think you can solve this by editing interaction between the two tables:

image.png

Select a visual and then click "None" on the other:
image.png
Do this on both.


Connect on LinkedIn

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.

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


Connect on LinkedIn

View solution in original post

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Top Solution Authors
Top Kudoed Authors