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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
SHAKEDALROY
Helper I
Helper I

Negative Numbers

Hi,

 

I'm trying to add a minus sign or  Parenthesis to the neagative numbers in a measure on my table visual.

Do i need to do it through DAX? beacuse i don't find a way to do it on the report..

 This is the muesure:

Change From PM = IF([Total Reports] = [DIFF from PM],BLANK(), [Total Reports] - [Reports Previous month])
 
Help will be much appreciated!
7 REPLIES 7
PaulDBrown
Community Champion
Community Champion

@SHAKEDALROY 

 

Can you post the code for the measures [Total Reports] and [Reports Previous month]?

 





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






v-jayw-msft
Community Support
Community Support

Hi @SHAKEDALROY ,

 

Can you share your measures to us? There are other rows show negative numbers, the problem may be on the measure.

 

Best Regards,

jay

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.
amitchandak
Super User
Super User

LP2803
Responsive Resident
Responsive Resident

@SHAKEDALROY Can you share an image of what you are trying to do? and how you want the output to be?

 

 

@LP2803 for ex - the second line in the Change From PM column is a negative number but it doesn't show it.

it suppused to be -24,986 or (24,986)

 

minus sign.jpg

@SHAKEDALROY 

 

I'm unable to produce your issue with my sample data.

 

But I think this might help

= Format([Measure],"#,##.#0;(#,##.#0)")

Make sure that you are not using ABS (Absolute) in meausre 







Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!

Proud to be a Super User!




Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.