Forum Discussion

Solution Sage

2 years ago

Solved

Formatting in a calculation group item

I made this calculation group items : So 3 pieces. But 2 of them are pecentages. The calculation group works just fine But when you select a percentage: I would rather have a d...

Need Help

audreygerred
2 years ago
Hello! You can create the format string to display as a percent. In Power BI, click on the calculation item that you want to format, then expand Formatting and toggle dynamic format string to on

Once it is on, you can enter the formatting you want:

For percent you can do "#.#%" or however many decimal places you want.

You can do the same in Tabular Editor 2.

audreygerred

Super User

2 years ago

That is odd. I am not sure why it is still showing 2 decimal places. When I do mine, it works. In the table on the left I have the calgulation group in and YoY% is showing 1 decimal place like I have it formatted to do, and in my table on the right I added in the measure I have explicitly defined and it is showing two decimal places (like that measure is formatted to do).