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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Negative & positive as Gain & Loss

Hi,

I'm sure someone can quickly help me with this.

How to display a negative value as a postive and vice versa in a visual , lets say on a card?

I have a calculated column containing -tive and +tive numbers where a negative value is the amount saved ( gain) and a positive value is the outgoing amount (loss). 

Is there a quick way to achieve this without amending the source file, just displaying the results of different calculations appropriately.

Thanks

 

 

1 ACCEPTED SOLUTION
timg
Solution Sage
Solution Sage

Hi Ha2san,

Creating a calculated column in which you multiply your original calculated column by -1 should do the trick. (Example: InvertedValue = [calculatedColumn] * -1)

 

Hope that helps!

 

Best regards,

 

Tim

 

 





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

Proud to be a Super User!




View solution in original post

3 REPLIES 3
Anonymous
Not applicable

Thanks a lot @timg. Also learnt that putting a 0- infront of a measure would do the trick as well.

measure= 0-Sum(table[calculated column]

Nice find, also a good alternative!





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

Proud to be a Super User!




timg
Solution Sage
Solution Sage

Hi Ha2san,

Creating a calculated column in which you multiply your original calculated column by -1 should do the trick. (Example: InvertedValue = [calculatedColumn] * -1)

 

Hope that helps!

 

Best regards,

 

Tim

 

 





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

Proud to be a Super User!




Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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