cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DKaur3 Frequent Visitor
Frequent Visitor

Stop filtering of one visualisation

Hello,

 

I have created a dashboard with several cards, bar charts and two scatter charts. The data ranges over ten years, so all the cards and bar charts show the latest year values when no year is chosen, and the correct values for the corresponding year when a year is chosen. I've done this using measure that check whether the year filter is being filtered. The problem I have is the scatter plots show data by year (along the x-axis), so all years have to be selected to show the full scatter plot. Is there anyway to have the scatter plot fixed such that it does not change when a filter is applied to the year? (Other filters should still update the scatter plot.

Any insight would be helpful.

Thanks,

D

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User
Super User

Re: Stop filtering of one visualisation

The new update did bring this feature in. I just greated a report with a bar graph that does not filter with the page slices so that I could show multiple years across it instead of the single year I want to focus on in the other visuals. In the edit screen there is a new button on the ribbon called visual interactions. Click it then click the strike through circle on the visualization you want to keep from filtering. Very simple and it worked quickly.

11 REPLIES 11
itchyeyeballs Established Member
Established Member

Re: Stop filtering of one visualisation

 
itchyeyeballs Established Member
Established Member

Re: Stop filtering of one visualisation

The slicers in PowerBi don't yet seem to have the ability to be linked to specific visualisations (Unlike in Excel)

PowerBIGuy Member
Member

Re: Stop filtering of one visualisation

@DKaur3 This could be accomplished via DAX. You could create a measure that  ignore the time slicer. Please see the following link.

Business Intelligence Architect / Consultant
JasonDunbar Regular Visitor
Regular Visitor

Re: Stop filtering of one visualisation

Could be that there's a much easier solution to your problem? In the November update of Power BI (http://blogs.msdn.com/b/powerbi/archive/2015/11/20/announcing-the-power-bi-desktop-november-update.a... there's the ability to change the interaction between visualisations.

 

Now, I've not yet tested whether or not this affects the visualisation when filters are applied - maybe not, or it could be that what you want to achieve can be done with a combination of this and a Report Level filter.

 

 

____________________________________________________
My other computer is an Azure data centre.
itchyeyeballs Established Member
Established Member

Re: Stop filtering of one visualisation

@PowerBIGuy I was originally thinking that when I posted my response but then wasn't sure if it would mean having to create a measure for each axis as well?

 

@JasonDunbar just tested your suggestion, seems to work well on slicers so should allow filtering some visuals to defined years and others to show all years.

DKaur3 Frequent Visitor
Frequent Visitor

Re: Stop filtering of one visualisation

Thanks guys, I found a workaround. I created a reference table with distinct years, then created a many to one relationship between the tables. Next I create a measure for my variable with ALL('Distinct years') in the formula, and my filter for the page (i.e. the other viz that I want to change by year) is by the distinct years too. This somehow works!

Highlighted
Super User
Super User

Re: Stop filtering of one visualisation

The new update did bring this feature in. I just greated a report with a bar graph that does not filter with the page slices so that I could show multiple years across it instead of the single year I want to focus on in the other visuals. In the edit screen there is a new button on the ribbon called visual interactions. Click it then click the strike through circle on the visualization you want to keep from filtering. Very simple and it worked quickly.

simony Frequent Visitor
Frequent Visitor

Re: Stop filtering of one visualisation

Hi 

I was just wonder if this work on powerbi desktop version as I can only find that ribbon in the service version? 

Cheers

Simon

NicholasH New Member
New Member

Re: Stop filtering of one visualisation

Hi - On the desktop Power BI, Select the visual that is providing the filter (like a specific slicer), then in the Ribbon under "Visual Tools" there is a button for "Edit Interactions".  After you click "Edit Interactions", on every other visual on the page you'll see some new icons in their upper right corners.  On the visual you no longer want affected by this fiter, select the circle with the slash through it.  Now that visual will no longer respond to your selected visual/slicer.