Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Table:
let
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}})
in
#"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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.