IF Statement Measure as an Slicer

[michael_knight]

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

[v-yuta-msft · Accepted solution]

@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.