Bug with dynamic format

[GeorgeVepkhvadz]

There is small bug with dynamic format.  If we change name of the table, in every measure formula for all columns or measures which are from that table are automatically changed. For instance if I change 'Table' to 'New Table'  in dax,  change will happen automatically. However, for dax in dynamic format the changes don't take place, and Measure breaks. 

[Anonymous]

Hi @GeorgeVepkhvadz ,

The FORMAT function can also be used in a measure DAX expression to conditionally apply a format string, but the drawback is if the measure was a numeric data type, the use of FORMAT changes the measure to a text data type. As a text data type the measure is then no longer usable as values in visuals.

Deep dive into the new Dynamic Format Strings for Measures! | Microsoft Power BI Blog | Microsoft Po...

Expression-based titles in Power BI Desktop - Power BI | Microsoft Learn

Create dynamic format strings for measures in Power BI Desktop - Power BI | Microsoft Learn

I have also found a similar post, please refer to it to see if it helps you.

Dynamic Format Strings Bug - Microsoft Fabric Community

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

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