Unanswered

"Periodically e-mail a Power BI scorecard status" formatting question on values and targets

(0) Share

Report

Posted on by jgray2

Hi - I'm using the template "Periodically e-mail a Power BI scorecard status", but I'm not able to figure out how to format the values. They are formatted correctly in the Power BI scorecard, but translating differently in the flow. Example is attached.

scorecard formatting issue.JPG

How can I format the values?

J. Gray

Categories:

Using flows

I have the same question (0)

All responses (5)

Answers (0)

Community Power Pla... on at

Like (0)

Report

Hi @jgray2 ,

My guess is you need to change Value and Target to percentage, you can use the Format Number action to get the desired result

https://www.shahryarsultan.com/2021/03/How-to-Format-Number-to-Percentage-in-PowerAutomate.html

Was this reply helpful? Yes No
jgray2 6 on at

Like (0)

Report

Hi - the additional issue is that some of those values should be percentages and some just numbers with a comma. I don't know how to format them individually. I was thinking maybe there is a setting that picks up the format from the source of the data vs. changing them.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

You can add a condition, for example, if the number contains "." then its percentage and if not then its number

Was this reply helpful? Yes No
jgray2 6 on at

Like (0)

Report

Hi - not all the values are percentages.

Was this reply helpful? Yes No
jgray2 6 on at

Like (0)

Report

Where would I apply the condition? I'm not sure of the steps and where to find any tutorials on writing an expression for power automate. Anything you can point me to would be helpful.

Was this reply helpful? Yes No