Slicer based on calculated column

[Oros]

Hello,

I have a calculated column (Net Sold).  How do I create a slicer based on the Net Sold column to filter my product table?  Thanks.

I would like to add a slicer based on the range of the Net Sold values so that I can add the "Good", "Bad" slicer.

[MNedix · Accepted solution]

Hi,

You add a new Column with a Switch function. In your case it should be something like:

G/B = SWITCH(
    TRUE(),
    Sheet1[Net Sold]>10,"Good",
    Sheet1[Net Sold]<10,"Bad")

Then, on the Report page, you add the G/B as a Slicer.

[Oros]

Thanks @MNedix 

It worked!