Showing results for 
Search instead for 
Did you mean: 

Calculation Group Format String Expressions not working with combined line and column charts

Since the February Power BI Desktop release came out reports including calculation groups with at least one format string expression do not show any line / column combination graphs anymore. In the service these visuals are not displayed and in the desktop an error is raised.

How to reproduce the issue:

1. open an empty file

2. create a query in the query editor


Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMtQz1DMyMLRU0lHKzwYShgYmSrE6MHEjA7i4EYq4IUzcxBxZHGxObmZxcWZeOpBlimEWQs7SFN08hJwhUF8sAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t, missing = _t, amount = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type date}, {"amount", Int64.Type}})
#"Changed Type"

3. create two measures

kpi amount = sum('Table'[amount])
missing% = DIVIDE(CALCULATE([kpi amount],'Table'[missing]="missing"),CALCULATE([kpi amount],all('Table'[missing])))

4. open tabular editor and create a calculation group with one item and set

expression: selectedmeasure()

format string expression: SELECTEDMEASUREFORMATSTRING ()

5. create the visual
-add a "line and stacked column chart",

-move  'Table'[Column1] to the shared axis

-'Table'[missing] to Column series
-kpi amount to column values

-missing % to line values


After this the visual is not rendered anymore and an error is raised.

This means that format strings expressions can not be used in any reports that use these visuals, and existing reports will not work properly currently.

Status: New
Community Support


This is a known issue and is under fix, will update here once I get any information.




Not applicable

We have excactly the same problem! The combined line and column charts is not working even if we are not using the Calculation Groups. when we delete the format strings in the Calculation Groups in the model (azure analysis services) it works. 

Not applicable

I have the same issue, looking forward for the solution.

Helper II

@v-lili6-msft  - This issue has been resolved in the Desktop version, however, facing challenge in PowerBi Service. Request you to please ocrrect in PowerBI service as well

Advocate I

The issue seems to be resolved now (Service and Desktop (2.90.1081.0)).


Helper II

@BjoernLueers - Yes, now it has been resolved on both area (Service & Desktop)

Frequent Visitor

I am experiencing this issue on Desktop 2.92.943.0 64-bit (April 2021) and when published to Service.


Is this issue still open/has it reoccurred?



Not applicable

I have the same issue (the latest version of a desktop and service). Adding any calculation to format string expression in calculation groups causes that formating for any measure disappears on some visualizations or variations of visualizations (all are like general formating). 

Advocate I

@Anonymous , this seems to be a different issue. The problem from this thread has been resolved by microsoft.

Not applicable

@BjoernLueers sorry, but it is the same issue. The problem is not resolved. In some visualizations, formatting string does not work. You can see on the attached picture. bug-formatting string.PNG