- 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
Join our Fabric User Panel
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Power BI Monthly Update - June 2025
Check out the June 2025 Power BI update to learn about new features.

User | Count |
---|---|
10 | |
9 | |
8 | |
7 | |
6 |
User | Count |
---|---|
15 | |
13 | |
11 | |
9 | |
8 |