Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Pikachu-Power
Post Prodigy
Post Prodigy

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?

 

1 ACCEPTED SOLUTION

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.

View solution in original post

4 REPLIES 4
v-stephen-msft
Community Support
Community Support

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.

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. 

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? 😐

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.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors