Dax / Viz : Plus/Minus format and conditionnal formatting

[jct999]

Hi all

Considering a measure, I would like to :

• Add + or - sign before the digits
• Apply conditionnal formatting to the value (ex. red if negative, green if positive)

I can add + or - sign with myMeasure = FORMAT( [Foo]+[Bar] ; "+0.0%;-0.0%"), but it seems to convert the measure to string.
In this case, we can't use Conditionnal formatting with string (correct ?)

One very uggly solution should be to create 2 measures :

• myMeasure1 = ... calculated ... , i.e wich type is numeric
• myMeasure2 = FORMAT( myMeasure1; "+0.0%;-0.0%"), which type is string.

Then apply conditionnal formatting on myMeasure2 according to myMeasure1 value.

Is there a more efficient and elegant solution ?

Regards

[amitchandak · Accepted solution]

@jct999 , Try format option on a column in the Model view

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-custom-format-strings