Add extra field with positive and negative category

[Anonymous]

Hello all,

This is my first post and I come from Tableau. Still getting used to the interface and all the options of Power BI.

I have the following table and I would like to add a column that would be the change Positive/Negative of the 'Change' field, so I can reflect it as a category and assign red color for negative and green for positive for example. In table is very easy to do with a table calculation. How is the way to do it on power BI? It does not need to be an extra column, I believe a calculated field would do.

Region	Change	Latitude	Longitude	Total value (bn)
North America	10.40%	40.29068	-97.2903	1000.6
Latin America	-27%	-1.24964	-64.9414	35.8
Europe	-38.80%	47.44149	10.714	391
MEA	222%	12.09571	25.7539	113.5
APAC (Excluding Japan)	-36%	28.9225	104.5195	241
Japan	2.40%	35.78759	138.3794	18.1

Thanks!!!

[Anonymous · Accepted solution]

HI @Anonymous ,

If you want a calculated Column you can use this DAX Columns formula:

Column = if ('Table (4)'[CHAnge]<0,"Negative","Positive")

You will get output some thing likt this.

 If you just want to highlight the positive and -ve values in the changefield itself than you can simply use th Conditional formatting on that columns and apply rules for the values <0.

let me know if this works.

Thanks,

Tejaswi