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 ,

 

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? 

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

    Hi NoaB ,

     

    Can you elaborate on your question please? What do you mean to send out an alert?

     

    Regards,

    MFelix

    • NoaB's avatar
      NoaB
      Frequent Visitor
      7 years ago

      Hi MFelix ,

       

      I've been looking into Power BI's functionality for sending out alerts. However it only works for livestream data for KPIs and gauges visuals. I was wondering if there functionality for a static data set that if the graph reaches a certain threshold a notification can appear.