- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
The matrix cell has to display the value as it is if its nonzero with leading special character
Hi All,
Input : Col1 Col2 Col3
AA $1,045 xxx
BB $0 yyy
Col2 : Decimal number, currency format.
The matrix must display the Col2 value as such if its > 0 and if its 0 then 0 without the $ symbol.
your input please?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
IF(<value>=0, FORMAT(<value>, "General Number"), FORMAT(<value>, "Currency"))
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
IF(<value>=0, FORMAT(<value>, "General Number"), FORMAT(<value>, "Currency"))
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you so much, its working.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I did it using power query,
Col2 => Decimal , Col2_copy => text
if [Col2_copy] = "0"
then "0"
else Text.Combine(
{ "$",
[Col2_copy
})
Output : $1045 , 0 [ since the datatype of the column changed to text , "," are gone. Is there any way to copy the data as such including its format?

Helpful resources
Power BI Monthly Update - July 2025
Check out the July 2025 Power BI update to learn about new features.

User | Count |
---|---|
25 | |
10 | |
7 | |
6 | |
6 |
User | Count |
---|---|
30 | |
11 | |
11 | |
10 | |
6 |