Leading 0 being removed from a decimal value after formatting

[andrew_wm]

Hello all,

I'm trying to get a KPI bot to display the proper number when sending the message through teams, which looks like this:

However, it looks like this in Power BI:

 

I'm using the Format Number function in PA to convert the float into 2 decimal places as required, yet it still removes the leading 0.

Using the 'create expression through example' option for the format does not work either, as it will either add a random non-specified number to the value, or not work at all.
Does anyone have any solutions to this? I'd be very grateful for any help

[v-xiaochen-msft · Accepted solution]

Hi @andrew_wm ,

I made a sample for you:

Enter custom value in Format.

Enter '#0.00'.

Save and run flow. The result retains the leading 0.

Best Regards,

Wearsky

[andrew_wm]

Hey, thanks for the reply

And no way it's that easy...

You're a genius thank you so much, it worked perfectly