Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!!!
Solved! Go to 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
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
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
98 | |
96 | |
68 | |
67 |