Forum Discussion
Sk1_2
2 years agoFrequent Visitor
Calculate difference between multiple columns and then highlighting the difference
Hello I am trying to calculate the difference between mutiple columns in PowerBI. And Highlight changes above and below 50 w/ color. I haven't been able to find any examples with multiple colum...
Sk1_2
2 years agoFrequent Visitor
Thank you! Can this formula work in a Matrix?
v-yanimei-msft
2 years agoCommunity Support
Sk1_2 , you can realize it in a Matrix. Now, I will show you how to realize it in a Matrix.
1.Modify the test table Table. Add a column ValueType, so that you can use it as the row later.
2.Add ValueType to Rows, and add Sum of 1, Sum of 2, Sum of 3, Sum of 4, Difference between Sum of 1 and Sum of 2, … to Values.
3.The outcome is in the following picture.
Best Regards,
Caroline Mei
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.