Formatting of calculation groups + display in matrix & charts

[ReneDH]

All,

For the creating of a report I'm struggeling with the following situation.

In the dataset have created multiple measures such as revenue (millions GBP), headcount (number), production volumes (thousands).

And with the tabular editor I created a calculation group which contains several calculated items which uses the above mentioned measures to extract the actuals, budget, and variance between those.

How can I generate the formatting of these calculated items in the right form?

If I use the SELECTEDMEASUREFORMATSTRING() in actuals and budget I will get when i select revenue as my measure back with the currency symbol, however this is not formatted into millions, if I then would do field formatting (in the matrix) I'm also formatting the variance calculated item into millions and loosing the numbers displayed over there.

What is the proper way to get the formatting right for a matrix table aswell for visuals such as the charts?

[v-stephen-msft]

Hi @ReneDH ,

Can you provide some dummy data and expected results?

For now, you can refer to the following article.

Reference: FORMAT function

                  Use custom format strings in Power BI Desktop

                  Data types in Power BI Desktop

Best Regards,

Stephen Tao

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

[ReneDH]

Hi Stephen,

To get some dummy data to put into here is not possible at the moment due to confidentality.

The Format function can't be used because it is a text format and not number (so cant be used for the visualisation in charts).

As said this topic describes my problem aswell and has also some dummy data.

Creating Value Dynamic Formatting using Calculatio... - Microsoft Power BI Community  

When I have time I will create some screenshots what I would like to reach.

[ReneDH]

In the meantime I found this article which encouteres almost the exact issues with the visuals that I tried to describe:
Creating Value Dynamic Formatting using Calculatio... - Microsoft Power BI Community  

Does anyone have a creative workaround to get this working in the meantime?