Make negative values return in Parenthesis and Red

[Anonymous]

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

[v-juanli-msft]

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]

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]

@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:

[Anonymous]

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:

[Anonymous]

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.