Forum Discussion

vjnvinod's avatar
vjnvinod
Impactful Individual
1 year ago
Solved

Crossh highliting issue

hi,   when i select my slicer i want to cross highlight, but its currently filtering out my visual see below. if i do the edit interaction it will show everything but not highligting what i have se...
Need Help
Show and Tell
  • danextian's avatar
    danextian
    1 year ago

    Your measure is probably returning zero. Can you try if([measure]<>0, [measure]) as the custom label.

     

     

vjnvinod's avatar
vjnvinod
Impactful Individual
1 year ago

danextian 

 

see below, in the table its filtering out and in the visual its highligting but turning the values to zero

 

danextian's avatar
danextian
Super User
1 year ago

I'm confused. You've selected AADC and the column chart values match those that are in the table. And since this is supposed to be cross-highlighting all other non-selected categories will still be visible but not highlighted.. What values do you expect to see from them other than those what's shown in the table?

  • danextian's avatar
    danextian
    Super User
    1 year ago

    Your measure is probably returning zero. Can you try if([measure]<>0, [measure]) as the custom label.

     

     

  • vjnvinod's avatar
    vjnvinod
    Impactful Individual
    1 year ago

    danextian  issue here is all other non selected categories "Data label" is 0, i want to still show the datalabel when its Cross highligting

  • danextian's avatar
    danextian
    Super User
    1 year ago

    As  shown in your screenshot is exactly what cross-highlighting does. Categories that are not selected or don't have a slice will show zero or blank.

  • vjnvinod's avatar
    vjnvinod
    Impactful Individual
    1 year ago

    danextian , okie may be thats how it works, so how do i avoid showing them as zero

    possible to show them as blank ? do i have to write some measure?