Forum Discussion
Bug with dynamic format
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.
1 Reply
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.
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 _ RongtieIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
