Unanswered

power bi values format

(0) Share

Report

Posted on by apenyaranda1985

Hello,

I have the following automated process where I collect values from power bi and add them to the template created from word. Among those values there are numbers which I would like to format.

Currently it adds them to me with many decimal places and I would like to put only two decimal places
Another value would like it to be with a % at the end

And on the other hand, I would like one of the columns of those values to store the total of the sum.

Would it be possible?

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

Joseph_Fadero 670 Power Up Champ - 2025 on at

Like (0)

Report

Hi @apenyaranda1985,

I trust you are good, in regards to formating the numbers, You can utilize Power FX to format the necessary values you need to populate in the word template,

In regards to needing one column to store the total of the sum, Can you provide further clarity to aid your request,

Kindly feel free to like my post and mark as a solution to aids others in the community

Was this reply helpful? Yes No
apenyaranda1985 62 on at

Like (0)

Report

Hello @Joseph_Fadero
I don't know Power fx but I'm going to look into it. I understand that the formulas I want to use are made directly in the word template?
On the other hand, about the total I want is the following.
I have a table in power bi with several columns, one of them is total sales where through power automate I am capturing the entire table in my word template, what I want is that at the end of the column total sales, apart from adding all rows, also add the sum of the entire column.

What I am trying that I have seen done is to do the formatting when I collect the values from power bi but I get the following error:

Unable to process template language expressions for action 'Format_number' at line '0' and column '0': 'The template language function 'formatNumber' expects its first parameter to be an integer or a decimal number. The provided value is of type 'String'. Please see https://aka.ms/logicexpressions#FormatNumber for usage details.'.

I have put the Format number action in Apply_to_each 2 and just below append array, I have also tried after appending array and the different function...

Was this reply helpful? Yes No