Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Vote for your favorite vizzies from the Power BI Dataviz World Championship submissions. Vote now!
hi Guys,
I am on DirectLake over OneLake. This is my data:
And power bi when I have currency shows this as this:
How to change format to see minuses.
Best,
Jacek
Solved! Go to Solution.
This is because of the locale. In the pane your looking at you can choose a locale that doesn't use the () like Chinese simplified (this keeps the dollar sign albeit from a different locale).
But the easiest way is to select Custom and then the correct code will appear (at least when I tried it after replicating your issue)
This will get you the following output:
This is the location:
You can change this by changing the locale settings.
and use custome settings.
The Power BI
Yes, as @ChielFaber has explained you can switch to Custom format, read more about it here:
Use custom format strings in Power BI Desktop - Power BI | Microsoft Learn
This is because of the locale. In the pane your looking at you can choose a locale that doesn't use the () like Chinese simplified (this keeps the dollar sign albeit from a different locale).
But the easiest way is to select Custom and then the correct code will appear (at least when I tried it after replicating your issue)
This will get you the following output:
This is the location:
Vote for your favorite vizzies from the Power BI World Championship submissions!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 11 | |
| 10 | |
| 6 | |
| 6 | |
| 6 |