Forum Discussion
Make negative values return in Parenthesis and Red
Hi Community,
I have the challenge of trying to make negative Decimal Numbers and Percentages appear in parenthesis.
The measures are calculated measures created in DAX for the Percentages and the other measures are calculated columns which are derived in Power Query.
From reading other posts (over a year) relating to the same topic, i see we can use the FORMAT() in DAX, however this will return the data as TEXT which i can imagine will cuase other issues as they are suppose to display as numerical values.
Has PBI got this as a functionality which i am unaware of or has anyone found an alterartive solution?
Thanks,
Laz
6 Replies
After 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
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:
