Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
PBI is new to me. In tableau I just had to pick 'difference' tab from the dropdown and that use to do the trick .I'm trying to calculate the difference between two rows in the matrix table
Actual data used to create the matrix
TEST_GROUP | AVG_BAL | AVG_1 | AVG_2 | AVG_3 |
TEST1 | 20 | 30 | 40 | 10 |
CTRL1 | 10 | 30 | 40 | 0.28 |
TEST2 | 30 | 30 | 40 | 0.09 |
CTRL2 | 40 | 30 | 40 | 0.09 |
CTRL3 | 50 | 30 | 40 | 0.04 |
TEST3 | 10 | 30 | 40 | 0.04 |
CTRL4 | 20 | 30 | 40 | 0.03 |
TEST4 | 10 | 30 | 40 | 0.03 |
CTRL5 | 30 | 30 | 40 | 0.03 |
TEST5 | 50 | 30 | 40 | 0.03 |
CTRL6 | 60 | 30 | 40 | 0.02 |
TEST6 | 70 | 30 | 40 | 0.02 |
CTRL7 | 80 | 30 | 40 | 0.02 |
TEST7 | 10 | 30 | 40 | 0.02 |
CTRL8 | 10 | 30 | 40 | 0.02 |
TEST8 | 10 | 30 | 40 | 0.02 |
TEST9 | 20 | 30 | 40 | 0.11 |
TEST10 | 10 | 30 | 40 | 0.04 |
Matrix- This is how my table looks like
groups avg-bal avg-1 avg-2 avg3
test 600 50 60 60
control 200 40 30 20
This is how I want my matrix table to look like
groups avg-bal avg-1 avg-2 avg3
test 600 50 60 60
control 200 40 30 20
Difference 400 10 30 40
Any help is appreciated!
Currently, there is no such a option that allow to change the Total row to Difference row. If you have any concern on this feature, you can submit your idea on the link below. If this feature was mentioned by mulitple users, product team will consider to add this feature to next release.
https://ideas.powerbi.com/forums/265200-power-bi-ideas
Thank you for your understanding.
Regards,
Charlie Liao
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
77 | |
68 | |
54 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |