Data types for visual calculations

[[email protected]]

This month, in addition to adding more formatting options to visual format strings, we've also enabled data types for visual calculations.


You can now define the data type for your visual calculations in the Visual Formatting panel, under the General > Data Formatting section.

Choosing the right data type is essential, as it not only affects how the visual calculation can be used in charts and calculations, but also determines the formatting options available for further customization. It is important to note that if the data type and the data do not match, the data type will be ignored. For example, if you have rows of data that contain “ABC” and you set the data type to “Decimal Number,” the data cannot be formatted as a decimal number and the data type will not be applied.

Please note that data type settings are only available for visual calculations, not for fields or measures, as their data type can only be set in the model.

Visual level format strings (preview)
In August, Power BI launched a new feature iran whatsapp resource called visual-level formatting chains. This tool allows users to customize the formatting of fields and measures directly in visuals, overriding any predefined formatting in the model. This makes it easier to get the desired formatting in a faster and more flexible way.

In these September Power BI updates, these visual-level formatting strings have been enabled by default and have been expanded to include more options than just custom formatting strings.

With automatic activation of visual calculations, visual-level formatting strings are also automatically activated. If you prefer to disable them, you can do so by disabling the visual calculations preview in Options & settings > Options > Preview features. It is recommended to keep them enabled to make formatting easier.