Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
uma_mahi
Frequent Visitor

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?

1 ACCEPTED SOLUTION
ray_codex
Resolver I
Resolver I

IF(<value>=0, FORMAT(<value>, "General Number"), FORMAT(<value>, "Currency")) 

View solution in original post

3 REPLIES 3
ray_codex
Resolver I
Resolver I

IF(<value>=0, FORMAT(<value>, "General Number"), FORMAT(<value>, "Currency")) 

Thank you so much, its working. 

uma_mahi
Frequent Visitor

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

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Kudoed Authors