Filter lock

[Anonymous]

Hi,

i have line chart with weeks on x axis. When i select one week on line chart values in tables chenge correspondingly. Now after i select one week on line chart and i want to select one of the rows in smaller table (because i want to see detailed data in table 3), values in smaller table doesn't stay the same (filtered by line chart), but they return to values of all weeks together.

Is there a way to lock filter (in this case line chart) so that i can select values in smaller table without them chenge to overall (summed for all weeks).

Interactions are set up in the way that selectiong anything in any table dont change line chart (black filled circle in Edit interactions mode)

tnx

[v-kelly-msft · Accepted solution]

Hi @Anonymous ,

Press Ctrl key when you wanna make and keep a second or more selections, it's a useful trick.

As you see below: My selections in the table below is kept in the small table above.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[Greg_Deckler]

@Anonymous Try holding down the Ctrl key when making your second selection. Totally read that title wrong the first time...

[amitchandak]

@Anonymous ,The information you have provided is not making the problem clear to me. Can you please explain with an example.

But are try to click on two visuals and keep both values. Try click after pressing ctrl