Forum Discussion

MYKJ's avatar
MYKJ
New Member
4 years ago
Solved

Slicer is Not Working

Hi all, I am getting a problem regarding a slicer. i made a measure Sensitivity which includes two measures like sell thru and net days. sensitivity measure are not appearing in Slicer. please help me out 

sensitivity =  If([Sell Thru] > 0 && [Sell Thru]<= 0.19 && [Net Days] > 15 && [Net Days] <= 30, "Critical",
If([Sell Thru] > 0.19 && [Sell Thru]<= 0.25 && [Net Days] > 15 && [Net Days] <= 30, "Average",
If([Sell Thru] > 0.30 && [Sell Thru]<= 0.35 && [Net Days] > 15 && [Net Days] <= 30, "Good",
If([Sell Thru] > 0.35 && [Sell Thru]<= 1 && [Net Days] > 15 && [Net Days] <= 30, "Excellent",
If([Sell Thru] > 0 && [Sell Thru]<= 0.35 && [Net Days] > 30 && [Net Days] <= 45, "Critical",
If([Sell Thru] > 0.35 && [Sell Thru]<= 0.45 && [Net Days] > 30 && [Net Days] <= 45, "Average",
If([Sell Thru] > 0.45 && [Sell Thru]<= 0.55 && [Net Days] > 30 && [Net Days] <= 45, "Good",
If([Sell Thru] > 0.55 && [Sell Thru]<= 1 && [Net Days] > 30 && [Net Days] <= 45, "Excellent",
If([Sell Thru] > 0 && [Sell Thru]<= 0.50 && [Net Days] > 45 && [Net Days] <= 60, "Critical",
If([Sell Thru] > 0.50 && [Sell Thru]<= 0.60 && [Net Days] > 45 && [Net Days] <= 60, "Average",
If([Sell Thru] > 0.60 && [Sell Thru]<= 0.70 && [Net Days] > 45 && [Net Days] <= 60, "Good",
If([Sell Thru] > 0.70 && [Sell Thru]<= 1 && [Net Days] > 45 && [Net Days] <= 60, "Excellent",
If([Sell Thru] > 0 && [Sell Thru]<= 0.64 && [Net Days] > 60, "Critical",
If([Sell Thru] > 0.64 && [Sell Thru]<= 0.75 && [Net Days] > 60, "Average",
If([Sell Thru] > 0.75 && [Sell Thru]<= 0.84 && [Net Days] > 60, "Good",
If([Sell Thru] > 0.75 && [Sell Thru]<= 1 && [Net Days] > 60, "Excellent"))))))))))))))))
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi  MYKJ ,

    Measure cannot be used in Slicer, you can consider creating a table to store the value of measure.

    Here are the steps you can follow：

    1. Use Enter data to create a table.

    2. Create measure.

    Flag =
var _selet=SELECTEDVALUE('Slice Table'[Slice])
return
IF(
    _selet=[sensitivity],1,0)

    3. Place [Flag]in Filters, set is=1, apply filter.

    4. Result:

    The column [Slicer] of the new table is used as a slicer, and when selected, the data corresponding to the sensitivity is displayed.

     

    Best Regards,

    Liu Yang

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

4 Replies

  • Tanushree_Kapse's avatar
    Tanushree_Kapse
    Icon for Impactful Individual rankImpactful Individual
    4 years ago

    Hi MYKJ ,

     

    Make this a Column and not a measure. And then use this column in your slicer field. this would work.

     

     

    Mark this as a solution, if I answered your question. Kudos are always appreciated.

     

    Thanks

    • MYKJ's avatar
      MYKJ
      New Member
      4 years ago

      Its only showing single row when i make this measure into column. 

  • Whitewater100's avatar
    Whitewater100
    Icon for Solution Sage rankSolution Sage
    4 years ago

    Hi:

    I think you would be better having set up a Sensitivity-Statusconfiguration table which you can run logic thru. I'd do that in excel and import it in.  Here's a rough version of a start of one: My answer is not conceptually differet than the first reply, just a few more details.

    SENSITIVITY TABLE

    StatusLow STHigh STLow DaysHigh Days
    Critical00.19015
    Bad00.191530
    Fair00.193050
    Better00.195070
    Best00.197090
    Critical0.190.25015
    Bad0.190.251530
    Fair0.190.253050
    Better0.190.255070
    Best0.190.257090

     

    Assuming these data points (Sell-thru & Days are in another Table you would make a new Calculated column in that table. You would use the values on this new calculated column for your slicer.  The Calculated Column/ Slicer could be a formula like this:

    Sensitivity =  CALCULATE(VALUES((SensitivityTable[Status]), 
    FILTER(Sensitivity,

    Table[Sell-thru] >= Sensitivity[Low ST] && Table[Sell-thru] < Sensitivity[High] && 
    Table[Days] >= Sensitivity[Low Days] && Table[Days] < Sensitivity[High Days])
    )

    This would put a Status on each row of the table where Sell-Thru & Net Days live. 

     

    Just need to make sure you have everything covered in the sensitivty table. (I didn't see a Sell Thru at .26 and Net Days between 15 -30 ..as an example.

     

    This could e not great performance wise if you have a lot of data due to how many breakouts you have. 

     

    Hope this helps!

     

    I hope this helps.

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi  MYKJ ,

    Measure cannot be used in Slicer, you can consider creating a table to store the value of measure.

    Here are the steps you can follow：

    1. Use Enter data to create a table.

    2. Create measure.

    Flag =
var _selet=SELECTEDVALUE('Slice Table'[Slice])
return
IF(
    _selet=[sensitivity],1,0)

    3. Place [Flag]in Filters, set is=1, apply filter.

    4. Result:

    The column [Slicer] of the new table is used as a slicer, and when selected, the data corresponding to the sensitivity is displayed.

     

    Best Regards,

    Liu Yang

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