Forum Discussion

michael_knight's avatar
michael_knight
Icon for Post Prodigy rankPost Prodigy
6 years ago
Solved

IF Statement Measure as an Slicer

Hi,

 

I'm wondering if it's possible to create a slicer which has results of an IF statement in. This is the IF statment

Spread Outcome = IF([Spread Offer Low] = [Final Option Price]&&[Spread Offer High]=[Final Option Price], "Fixed",

IF([Average Sum] >= [Final Option Price], "Low",

IF([Average Sum] < [Final Option Price], "High")))

And I want to create a slicer with "Low", "High", Fixed", just like so...

 

Thanks,

 

Mike

Need Help
Tips and Tricks
  • v-yuta-msft's avatar
    v-yuta-msft
    6 years ago

    michael_knight ,

     

    Only column can be used in a slicer, so you should convert this measure into calculate column.

     

    Community Support Team _ Jimmy Tao

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

1 Reply

  • v-yuta-msft's avatar
    v-yuta-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    michael_knight ,

     

    Only column can be used in a slicer, so you should convert this measure into calculate column.

     

    Community Support Team _ Jimmy Tao

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.