Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
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
Proud to be a Super User!
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!
Proud to be a Super User!
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
Proud to be a Super User!
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |