This post is also available in: Deutsch Automatic scaling of metrics or measures is possible in Power BI for just about any visual. However, there is currently no possibility to dynamically adjust tables or the matrix. With this selection the values can be displayed in millions, for example. Even if the values are restricted due to a slicer, filter or drill down, the manually set scaling is kept. Depending on the constellation, this leads to the strange situation that no more information can be obtained from the report because the values are too low for scaling. While this is handled in a graphical visual and the scaling is adjusted, this option is unfortunately not available in a table or matrix. Dynamic scaling with DAX However, you can influence the formatting directly in a DAX measure so that it automatically adapts to the displayed value. The FORMATfunction will help us here. This function is similar to the formatting in Excel and only allows us to adjust the visualization, the values remain unchanged. The following syntax would display the value as a normal number: The documentation for custom formats shows us that a comma helps to “shrink” the displayed number in […]