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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
kaym
Helper I
Helper I

Power BI Alert Email Not Showing the Current Value of the Measure

Hello,

I tried to setup a trigger for a measure in my Power BI report.

kaym_0-1706651167655.png

However, the email content is not showing me the current value of the measure. All it shows me is this:

kaym_1-1706651223497.png

 



 

2 ACCEPTED SOLUTIONS

Hi @kaym ,

According to your screenshot, you may not have created a New Property. You need to create a property for your measure beforehand before you can put it in the Additional information.
Please follow the next steps:

vjunyantmsft_0-1706748956018.png

vjunyantmsft_1-1706749203029.png
Or here:

vjunyantmsft_2-1706749217459.png

When you see it showed here:

vjunyantmsft_3-1706749289320.png

Then you can select it here:

vjunyantmsft_4-1706749321502.png


Best Regards,
Dino 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

Hi @kaym ,

When you create the measure, had you clicked here to change the value into percentage?

vjunyantmsft_0-1706833070482.png

If you've already set it up, but it's still presented as a decimal, then there's no way to set up how the measure is displayed in the email.

Best Regards,
Dino Tao

View solution in original post

6 REPLIES 6
kaym
Helper I
Helper I

@v-junyant-msft 

Hi Dino,
Thank you so much! This solved the problem, I can now see the value in my email now:

kaym_0-1706799747653.png

 

However, do you know how I can see that value (0.0689) in percentage? The measure is a percentage column. 

Hi @kaym ,

When you create the measure, had you clicked here to change the value into percentage?

vjunyantmsft_0-1706833070482.png

If you've already set it up, but it's still presented as a decimal, then there's no way to set up how the measure is displayed in the email.

Best Regards,
Dino Tao

hi Dino!

I did set it up as %. seems like I will have to stay with a decimal value. Thanks though!

v-junyant-msft
Community Support
Community Support

Hi @kaym ,

After my test, when you set Triggers, please add contents you want to see in the Additional information.
For example:

vjunyantmsft_0-1706663060740.png

vjunyantmsft_0-1706663955591.png

And here is the email I received:

vjunyantmsft_2-1706663277294.png

Here's the overall layout:

vjunyantmsft_0-1706664134246.png


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

Hello Dino @v-junyant-msft !

Thank you for your detailed reply. When I try to put additional information I am unable to do it:

kaym_0-1706717794149.png

I see a red cross when I hover over it

Hi @kaym ,

According to your screenshot, you may not have created a New Property. You need to create a property for your measure beforehand before you can put it in the Additional information.
Please follow the next steps:

vjunyantmsft_0-1706748956018.png

vjunyantmsft_1-1706749203029.png
Or here:

vjunyantmsft_2-1706749217459.png

When you see it showed here:

vjunyantmsft_3-1706749289320.png

Then you can select it here:

vjunyantmsft_4-1706749321502.png


Best Regards,
Dino 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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.

Top Kudoed Authors