Forum Discussion

NoaB's avatar
NoaB
Frequent Visitor
7 years ago
Solved

Change horizontal/constant line based on slicer selection

Hi,   Is there a way to change the constant line based off the slicer selection? I have a slicer with four different options and each of them have different capacities. Is there a way for a constan...
Need Help
  • MFelix's avatar
    MFelix
    7 years ago

    Hi NoaB ,

     

    You need to add a measure that makes the calculation for each of your option on the slicer, something like this:

     

    Flat Line =
SWITCH (
    SELECTEDVALUE ( Table2[Capacity] );
    "A"; 20;
    "B"; 25;
    "C"; 5;
    "D"; 40;
    80
)

    This needs to be adjusted to your needs but as you can see below the numbers change accordingly

     

     

    Regards,

    MFelix

MFelix's avatar
MFelix
Icon for Super User rankSuper User
7 years ago

Hi NoaB ,

 

You need to add a measure that makes the calculation for each of your option on the slicer, something like this:

 

Flat Line =
SWITCH (
    SELECTEDVALUE ( Table2[Capacity] );
    "A"; 20;
    "B"; 25;
    "C"; 5;
    "D"; 40;
    80
)

This needs to be adjusted to your needs but as you can see below the numbers change accordingly

 

 

Regards,

MFelix

  • NoaB's avatar
    NoaB
    Frequent Visitor
    7 years ago

    Hi MFelix ! Thanks for your response!

     

    I tried your approach and I'm still having some issues. Is Table2[Capacity] the table that has a column "Capacity" which results in the options for the slicer?

     

    I attempted thios measure below and was receiving an error "Unexpected expression" for everything starting after the semicolon after "SELECTEDVALUE( HourlyCapacityWithETA[PoolName] );" 

     

    Flat Line =
    SWITCH(
    SELECTEDVALUE( HourlyCapacityWithETA[PoolName] );
    "Var1"; 220;
    "Var2"; 220;
    "Var3"; 70;
    "Var4"; 364;
    )
     
    Thanks for your help!
    • MFelix's avatar
      MFelix
      Icon for Super User rankSuper User
      7 years ago

      Hi NoaB ,

       

      This as to do with regional settings, on some systems it uses the dot comma on other only comma.

       

      Redo your measure to:

       

      Flat Line =
SWITCH(
SELECTEDVALUE( HourlyCapacityWithETA[PoolName] ),
"Var1", 220,
"Var2", 220,
"Var3", 70,
"Var4", 364
)

      Regards,

      MFelix

      • NoaB's avatar
        NoaB
        Frequent Visitor
        7 years ago

        Amazing! Thank you MFelix !

         

        Do you know if there is a way to send an alert for static data when the data crossed the capacity line?