cancel
Showing results for 
Search instead for 
Did you mean: 
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.

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors
Top Kudoed Authors