Forum Discussion
Helper Iparentheses/brackets for negative percentage
Hi Experts,
As we know that Pie chart does not show negative value. In order to overcome this i am multiplying the value by -1. however is it possible to show the value in parentheses/brackets?
below is the formula i am using to cacluate the value.
Regards
Hi Gaurav_84 ,
Please refer to this video: https://www.youtube.com/watch?v=mHU9RRMhRwg
This is my test:
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
WinnizIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
- mahoneypat
Microsoft Employee
You can use custom format strings to display negative values in parentheses (not sure that works in a visual), but once you multiply by -1 you have a positive number and the custom string won't be applied. You could make it with the charticulator visual, if you have one measure with *-1 and a second with the value to be used in a text box.
Pat
v-kkf-msftCommunity Support
Hi Gaurav_84 ,
Please refer to this video: https://www.youtube.com/watch?v=mHU9RRMhRwg
This is my test:
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
WinnizIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
