Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
We have 2 bar postive and negative. if value is 0.0, it is showing negative, Which is not correct. Please halp on this.
Solved! Go to Solution.
Are you sure the data involved is actually 0, and not some very small negative value that's rounding to zero based on your number of decimal points formatting?
Yes, I just checked. the value is -0.03. But if i want to show it at 1 decimal place. How I can resolve it. Data with data color
If you want to deny that -0.03 is, in fact, negative, then do some rounding in the actual measure itself so that the value you get out is actually zero, not just displaying as such - something like newmeasure = mround([existingmeasure],0.1) should do the trick
Hi @Mariusz
Conditional formatting:
And also whereI am showing it, screenshot:
Fied formatting:
Thanks
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
116 | |
105 | |
69 | |
67 | |
43 |
User | Count |
---|---|
148 | |
103 | |
103 | |
88 | |
66 |