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 of the Net Sold values so that I can add the "Good", "Bad" slicer.

 

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.

2 Replies

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