Forum Discussion

dk_24's avatar
dk_24
Helper I
8 years ago
Solved

Peer 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 b...
Need Help
  • v-caliao-msft's avatar
    v-caliao-msft
    8 years ago

    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

v-caliao-msft's avatar
v-caliao-msft
Microsoft Employee
8 years ago

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's avatar
    dk_24
    Helper I
    8 years ago

    Thanks Charlie Liao, for workaround solution.

  • dk_24's avatar
    dk_24
    Helper I
    8 years ago

    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.