This post is also available in: Deutsch

In September last year I had already written an article on how to dynamically adjust the values of a measure, for example in millions, thousands or without scaling:

Dynamic scaling of a measure in Power BI with DAX

The approach at that time with the FORMAT function had a big disadvantage, the value is always converted to a text with FORMAT. This means that the measure can only be used in tables, because bar and line graphics cannot display texts.

With old approach representation only possible in tables

In the meantime, however, there is a much better way to display a measure with dynamic formatting using Calculation Groups. With Calculation Groups I can also create the formatting dynamically