Please note javascript is required for full website functionality.

Blog

Power BI Blog: Dynamic Format Strings Now Supported for All Chart Elements

7 April 2022

Reports with AS data sources can provide dynamic format strings, or cell-level formatting, to customise the formatting of their data.  Reports with calculation groups will also convert regular format strings into dynamic format strings.  Microsoft has admitted they have received feedback that these dynamic format strings were applying inconsistently across a number of different visuals, including the gauge visual and some cases of categorical bar charts.

Noting that this inconsistency has affected decisions surrounding report design, this update now supports categorical visuals (hopefully) for all support dynamic format strings. As an example, here is how a gauge visual might display a value string with commas to separate thousands before the changes:

and this is how it should do it now:  

Check back next week for more Power BI tips and tricks!  

Newsletter