Highlight In Table Based on Non Filtering Slicer

[Anonymous]

Hello everyone,

I got a report that has a synced slicer for the acct mgrs across all tabs. The rest tab of the report is an overview, which has aggregated totals of all acct mgrs in a table, along with their rank. This table is set to not be filtered by the acct mgrs slicer by going to "Edit Interactions" and selecting "None" because I need to have all the acct mgrs to show YTD totals for sales, profit, etc, and rank them in each of the respective tables. What I want is the acct mgr slicer to conditionally highlight the tables for that acct mgr, so it's clear to them where they stand in the ranking. My problem arises from having set the interaction to none. If I hadn't, it would be a lonely table of one acct mgr, which defeats the purpose. 

Any formulas I've created end up highlighting all the acct mgrs, unless I have it driven off of a separate slicer I created from a disconnected table, which is not a long term solution. I need it to be driven off of the acct mgr slicer that drives the whole report.

Does anyone have any suggestions?

[Anonymous]

@v-xuding-msft 

I should have initially added screenshots. This is my landing page on the reports, the slicer option on the right currently is set to JP, as is my separate slicer to highlight him in the table. I created a disconnected table to select the highlighting, with this formula:

It would really be awesome if it could be boiled down to the one account manager slicer, so it wouldn't be so blocky to the end user. 

[v-xuding-msft]

Hi @Anonymous ,

For your situation, it is the best way to use a separate slicer from a disconnected table. When we set interactions to none, the visual will show all the values and we can't do any conditional operation based on slicers.  Or maybe you could show values with different colors to distinct mgrs if you don't want to use a separate slicer.

ExampleExample

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.