Keep a currently Filtered Visual while Filtering another Visual

_eNVy_

Board Regular
Joined
Feb 9, 2018
Messages
66
Office Version
  1. 365
Platform
  1. Windows
Hi all,

I wonder what I am doing wrong or maybe I have missed something.

When I filter on the 164 Due more than 3 Weeks the Within Timescale visual updates (brilliant).

1623243393054.png


If I then select the 1 False the Visual updates as well the the one to the left (image below).
This then has a knock on affect with my table of information (I would have hoped to see 1 row of data in my table but depending on which filter was selected last, I would either get 164 or 73 rows in my table).


1623243475110.png


Thank you in advance.
 

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.
With a visual selected, go to the Format tab and press Edit interactions. The icons that appear over each visual allow you to control which visuals get filtered from the current visual and which will not be affected. Change how visuals interact in a report - Power BI

So for your example, if you edit interactions for the Due Bandings visual, the Within Timescale visual would be set to "Filter". If you click on the Within Timescale visual and edit interactions, the interaction with the Due Bandings visual would be "None" (if that is your intended behavior).
 
Upvote 0

Forum statistics

Threads
1,214,589
Messages
6,120,415
Members
448,960
Latest member
AKSMITH

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top