Visual filtering

Question

Hi&nbsp;I have a dashboard built in which there is two slicers on the main page, these slicers control the the filters for all other pages and are synced.&nbsp;on one page I have two visuals. One is a graph and the other is a details table (i.e customer details).&nbsp;I want the graph to filter the details table, but I want the Details table to ignore all other slicers and just use the graph. is this possible?&nbsp;thanks&nbsp;

v-yuta-msft · Answer

Anonymous&nbsp;,
&nbsp;
Click the graph visual, then click Format-&gt; Edit interactions, then select the disable icon in right-top hand of the two slicer visuals.
&nbsp;&nbsp;
&nbsp;&nbsp;
&nbsp;
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

nishantjain · Answer

Just to add to the previous suggestion, you need to unhide the synced slicer on the page

When you sync slicers across multiple page, each slicer is copied in each page but is hidden. You can unhide the slicer from the selection pane or sync slicer pane

Once you unhide the slicer, follow the instructions from the previous post and then hide the slicer again

anonymous · Answer

thanks, I did this but it is still ommitting results.&nbsp;&nbsp;

nishantjain · Answer

What do you mean that it is still ommitting results?

A synced slicer works exactly the same way as a normal slicer so I expect it to work.

You can also check this by creating a blank page and copy the 2 visuals you have. Make sure you don't sync any slicers. Now sync one slicer at a time and change it's interaction with the 2 visuals and analyse the impact. I am sure you will spot something

anonymous · Answer

I created a new filter, basically there is an issue with where it is pulling the data.&nbsp;I have two tables both with the ID of Name, I have them both linked to the main data table as a relationship but it appears as though this isn't working correctly&nbsp;&nbsp;the only reason I hav two tables in the first place is because I can't get a calculation to work in the main employee table. the table has a column for names, but there are two corresponding columns in the main data table. so the relationship that I have is between the Table-Name column and the Data-name1 column. so my second formula which is meant to check the Data-Name2 column, is the one that isn't working.&nbsp;so I created a whole new table, created the relationship and then the formula worked. but now its not showing the right customer details in the visuals. if I could somehow get the formula to work then I could get rid of the second table and the problem would be solved.&nbsp;the formula I wrote as a measure is:&nbsp;Name2 calculation = SUMX(Data,CALCULATE(SUM(Data[Utilisation]),USERELATIONSHIP('Employee List'[Name1 List],Data[Name2 Clean]),FILTER(All('Employee'),'Employee List'[Name1 List]=Data[Name2 Clean])))&nbsp;if you can help me get that one working then I think it will fix the visual issues as well.

Forum Discussion

Visual filtering

9 Replies

Related content

Date filters for Visualization

Filters issues in visual objects

Filter on Visual Row Context

Filter on table visual

Table visual filtering