Forum Discussion
Make negative values return in Parenthesis and Red
Community SupportAfter searching and testing, i can't find any other way to make negative values return in Parenthesis and Red without "format" function.
My test is as below
Create measure3, 4 based on measure1,2
Measure3 = FORMAT([Measure 1],"#,##0.00;(#,##0.00)") Measure4 = FORMAT([Measure 2],"#,##0.00%;(#,##0.00%)")
Then set conditional formatting for [Measure3] and [Measure4]
which issue do this method cause? could you share here so i would try to work out it?
For your requirement, you can submit a idea here.
Best Regards
Maggie
Hi Maggie,
Thanks for your reply on this issue.
In my case i want to showcase the Measure3 Positive values as green font color. Can you please provide the solution how to do it.
- themistoklis
Community Champion
Anonymous
On the conditional formatting window simply click the add button on the right to add a new line put the values shown on the following image:
Hi Themistoklis,
Its Worked for me. Thanks a lot for your quick reply.
I have requirement to customize the matrix column header based on expression in power bi. Can you please let me know the solution.
Hi Themistoklis,
Its Worked for me. Thanks a lot for your quick reply.
- themistoklis
Anonymous
I cant think of a way to change the column header based on expression. But in general you can do it like this:
See image below:
