Forum Discussion
Helper IPeer to peer comparision
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
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
3 Replies
v-caliao-msftMicrosoft Employee
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