Forum Discussion
Visuals Displaying Negative Values as Zero
I have a measure which takes the difference of two measures (column 3 = column 2 - column1 in the image below) to show change over time. However, in multiple types of visuals (ex., card, matrix), all negative values render as zero. The grand total in a matrix also shows zero, which is only possible if some values from the expression are negative because the total of all values must be zero for this particular measure, so I know the issue relates to rendering negative values rather than not calculating negative values. Does anyone know why this might occur?
2 Replies
- AnonymousNot applicable
Just check the formatting on the field and do not under any circumstances format the output of measures using the FORMAT function.
- AnonymousNot applicable
Hi Anonymous ,
Can you provide your formula of your measure? If so, can you give me your sample data? Remember to hide your private data.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.