Forum Discussion
DirectQuery Connection Showing Format Strings Instead of Numeric Values
Hello Power BI Community, We've encountered an issue when connecting to our semantic model using DirectQuery—most values in our dashboards are now being displayed as format strings rather than th...
The problem presented itself in Power BI Service as well. Updating desktop versions was not the solution.
Hi Jelle-Scheper ,
You can apply the FORMAT function as shown below to achieve the expected results, even when using DirectQuery mode. This approach has worked for me, please refer to the screenshot below for reference. Let me know if it doesn’t work on your end.
NetSalesFormatted =
FORMAT(SUM(Customers[ID]), "-€\ #,0")
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Thank you!!