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
Advocate I

It looks like this issue returned but only in Power BI Desktop so far no problems in the Service (Tested with Version: 2.100.1182.0)