Dynamic formatting applied inconsistently to Calculation Groups in Matrix report

[Tattysnuc]

Hi Fellow Power Bi-ers,

I have a MATRIX report where we utilize the calculation groups in headers, and we show the other measures in the rows, however the formatting is being applied inconsistently:

The rows contain measures, leveraging the "switch values to rows" feature in the matrix visual are of mixed data types - decimals, integers and percentages.

The calculation GROUPS contain different versions of those measures (ie this year, last year, next year for instance) and then we've calculated the absolute and percentage difference between them.... but then noticed this formatting issue.

it seems as though where the rows are formatted in percentage (ie the same "Type") as calculation group, it applies the 1 dp formatting that we are applying via dynamic formatting.  However for all the rest where the row is of an integer or decimal type, then the calculated percentage which, is certainly NOT an integer, is being rounded to 0dp.

How would I force 1dp to the calculation group?  I've tried removing and then reapplying all the formatting and, up to the point where you apply the dynamic formatting it works ok, however it seems that where we have "conflicting" formatting, there is no way to over-ride the number of dp shown or even set the precedence.

Has anyone else experienced this and, if so, how did you resolve it?

Many thanks in advance

Mike

[Anonymous]

Hi @Tattysnuc 

Can you tell me if your problem is solved? If yes, please accept it as solution.

Regards,

Nono Chen

[Anonymous]

Hi @Tattysnuc

I understand your issue may be that the format of the percentage values in the calculated group is inconsistent compared to other data types such as integers and decimals.

To solve the problem of enforcing a consistent use of one decimal place for calculating percentage differences in a group, you can use a custom format string. You can try the following:

Open Power BI Desktop and navigate to the modeling view.

Select a measure that represents the percentage difference in the Calculation group.

In the Properties pane, click the drop-down arrow under Format.

Select Custom from the Format drop-down menu.

Enter the custom format string "0.0%" (without quotes) in the Custom Format field.

This custom format string ensures that your percentage values always display one decimal place.

You can view the link below for more details:

Use custom format strings in Power BI Desktop - Power BI | Microsoft Learn

Regards,

Nono Chen

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