Forum Discussion
DirectQuery Connection Showing Format Strings Instead of Numeric Values
Hi Jelle-Scheper ,
Thank you for reaching out to Microsoft Fabric Community.
I used the same measure that you provided and tried to replicate the issue, but it’s working fine on my end. Please see the screenshot below for reference.
Please try installing the new version of power bi desktop file from here (https://www.microsoft.com/en-us/download/details.aspx?id=58494 ). Let us know if you are still facing the same issue.
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!
Thanks & Regards,
Rekha,
Customer Support Team.
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!!
That would result in an unsortable measure in tables as you would sort on a text data type. We've found our own solution now that does not involve such comprimises. Thanks!
Hi Jelle-Scheper ,
Glad to hear you found a solution! If possible, could you please share it here and mark it as the accepted answer? It would be really helpful for others who might run into the same issue.
Thank you!!