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!The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live 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:
| User | Count |
|---|---|
| 19 | |
| 13 | |
| 9 | |
| 8 | |
| 7 |