How to apply conditional formatting/ or create a measure to use conditional formatting

[Schanice]

Hey guys

Very new to Power BI.

I've tried googling the answer, but can't seem to find what I'm after. Maybe 'cause it can't be done? So I thought I'd direct my question to the gurus. 

I'm trying to apply conditional formatting to a table in Desktop BI, on a column difference, as a currency, but when I try to highlight the negative figures in red, and positive in green. But, as it has parentheses denoting that it is a negative number, I can't enter the parentheses as a value in the data bars format. 

As an example, positive number is $692,477 and negative number is ($369,459)

Do I create a measure allowing me to add this ( ? Or can I format the $ column, to remove the ( and change it to a -? 

Also, the 2 columns, that I'm using to create the difference column, are calculated meausres. So that also seems to be an issue.. 

SEND HELP! 🙂

[v-yinliw-msft · Accepted solution]

Hi @Schanice ,

You can try this method:

Sample data:

MeasureF = SUM('Table'[First]) 

MeasureS = SUM('Table'[Second]) 

MeasureC = [MeasureF] - [MeasureS] 

ConditionalFormat =
SWITCH ( TRUE (), [MeasureC] < 0, "Red", [MeasureC] >= 0, "Green" )

The result is:

Hope these help you.

Here is my PBIX file.

Best Regards,

Community Support Team _Yinliw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[TomMartens]

Hey @Schanice ,

first - welcome to Power BI and welcome to this community.

It's always very helpful if you provide a pbix file that contains sample data but still reflects your data model (tables, relationships, calculated columns, and measures). Upload the pbix file to onedrive, google drive, or dropbox and share the link. If you are using Excel to create the sample data instead of the manual input method, share the Excel file as well.

Sample data is always very helpful. Sample data avoids misunderstanding and finally safes a lot of time.

Regards,

Tom