Peer to peer comparision

[dk_24]

Hi All,

how to hilight the pariticular row in a table based on the slicier selections ?

in the below screenshot , if i selected "India" in slicer , need to hilight that particular india row in below table instead of filtering.

how to achive this ? /is there any workaround for this. any help is much appriciated.

please find the below screen shot

[v-caliao-msft · Accepted solution]

@dk_24,

Currently, there is no such a function to achieve this requirement.

To work around this, we can create a measure to check if current item is selected in slicer. Then add this measure to your visual and conditional format this measure.

Measure =
var selecteditem = IF(HASONEFILTER(Slicer[Slicer]),LASTNONBLANK(Slicer[Slicer],1),BLANK())
return IF(ISERROR(SEARCH(MAX(Sales[Group]),selecteditem)),0,1)

Regards,

Charlie Liao

[dk_24]

Hi Charlie Liao,

Can we implement this whitout extra slicer table.why because i have multiple visulizations on the same page. i have to give single slicer to all the visulazations to filetr in the page.

Thanks,

Koti.

[dk_24]

Thanks Charlie Liao, for workaround solution.