Forum Discussion

Pikachu-Power's avatar
Pikachu-Power
Icon for Impactful Individual rankImpactful Individual
5 years ago
Solved

Alert for percent dont work

hi all,

 

i have a card with a percent value. it is currently 44 %. when i create an alert on the dashboard with 40 or 0.4 i dont get an alert / an e-mail. For a normal number it works in a card or kpi.

 

the percent value is a measure like 

 

Measure_Percent =
VAR V1_ = [Variable1]
VAR V2_ = CALCULATE(SUM(Table[Column]))

RETURN
V1_ / V2_
 
So what i do wrong?

 

  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Pikachu-Power ,

     

    For now, it can only be done as you said.

     

    Best Regards,

    Stephen Tao

     

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

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Pikachu-Power ,

     

    Please review the Considerations and troubleshooting

    • Alerts aren't supported for card tiles with date/time measures.
    • Alerts only work with numeric data types.
    • Alerts only work on refreshed data. They don't work on static data.
    • Alerts only work on streaming datasets if you build a KPI, card, or gauge report visual and then pin that visual to the dashboard.

    As mentioned above, Alerts only work on streaming datasets if you build a KPI, card, or gauge report visual and then pin that visual to the dashboard.

     

     

    Best Regards,

    Stephen Tao

     

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

    • Pikachu-Power's avatar
      Pikachu-Power
      Icon for Impactful Individual rankImpactful Individual

      So Alerts only work with numeric data types would mean that i cant use alerts for a percent format?

       

      i have two numeric values A and B. And i want an alert when A exceeds B, more precise when A / B is over 100%. Sounds strange that this is not possible 😐

       

      When i just use A in the card and enter B as limit it works and i get an alert. But B can change so I need the percentage. 

      • Pikachu-Power's avatar
        Pikachu-Power
        Icon for Impactful Individual rankImpactful Individual

        When I use a numeric value 0,44 instead of 44% in the card or kpi it works. so it looks like that i need a separate card or kpi in a numeric version just for the alert which i may hide in a power bi desktop side. Right? 😐