Forum Discussion

jcastr02's avatar
jcastr02
Icon for Post Prodigy rankPost Prodigy
5 years ago
Solved

Stacked Slicers

I have a stacked slicer visual.  I'd like to just filter out the blanks when the first field is "No".  When I remove blanks in the filters for this visual, the blanks for the "yes" disappear and I'd like to keep those.  Any suggestions?

 

  • jcastr02 , Create a new column in you table

     

    flag = if([W@H] = "No" && isblank([Y/N]) , 1, 0)

    put a visual level filter flag =0

1 Reply

  • jcastr02 , Create a new column in you table

     

    flag = if([W@H] = "No" && isblank([Y/N]) , 1, 0)

    put a visual level filter flag =0