Forum Discussion

Mahmed1's avatar
Mahmed1
Icon for Helper IV rankHelper IV
2 years ago

Check selected row against Selected values from Slicer

Hi   im trying to a put a 1 against each row where the the current row matrix interval = the slected values in the slicer (multiple selection rather than single value is possible)   ive tried the...
SELECTEDVALUE
Mahmed1's avatar
Mahmed1
Icon for Helper IV rankHelper IV
2 years ago

Hi yes they are connected

 

Infact they are coming from same table

 

so all i wanted to do is if the current row time in the matrix visual (say 08:00) is = to whats selected in the slicer ie (say slicer selected value is 08:00 and 09:00) then put a 1

 

the formula for time is coming from same table

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    2 years ago

    That won't work as they already share the filter context. At a minimum your slicer needs to be fed by a disconnected table.

    • Mahmed1's avatar
      Mahmed1
      Icon for Helper IV rankHelper IV
      2 years ago

      Oh ok - so how can i reference the time column from this table but keep it disconnected 

       

      i guess then my formula would work right?