Forum Discussion

Oros's avatar
Oros
Icon for Post Prodigy rankPost Prodigy
2 years ago
Solved

Slicer based on calculated column

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...
Need Help
  • MNedix's avatar
    MNedix
    2 years ago

    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.

MNedix's avatar
MNedix
Icon for Solution Sage rankSolution Sage
2 years ago

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's avatar
Oros
Icon for Post Prodigy rankPost Prodigy
2 years ago

Thanks MNedix 

 

It worked!