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