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.
Hi all,
I have a matrix visualization with some sum of amounts for value and Q1, Q2, Q3 and Q4 for columns.
I need a subgrouping for each quarter. The underlying table does have a flag column and my subgrouping should show the sum of amounts for each quarter when the flag is set on 0 and alternatively, when it is set on 1.
Namely from this:
Q1 | Q2 | Q3 | Q4 | |
Point A | 100 | 200 | 250 | 150 |
Point B | 250 | 350 | 200 | 100 |
Point C | 300 | 400 | 500 | 300 |
I need to do this:
Q1 | Q2 | Q3 | Q4 | |||||
myFlag = 0 | myFlag = 1 | myFlag = 0 | myFlag = 1 | myFlag = 0 | myFlag = 1 | myFlag = 0 | myFlag = 1 | |
Point A | 40 | 60 | 60 | 140 | 50 | 200 | 30 | 120 |
Point B | 50 | 200 | 60 | 290 | 40 | 160 | 20 | 80 |
Point C | 80 | 220 | 90 | 310 | 80 | 420 | 30 | 270 |
Thanks,
vv
Solved! Go to Solution.
@vrv , have you used expand icon?
@vrv , if the first one is matrix then you should able to add a flag and expand it.
The information you have provided is not making the problem clear to me. Can you please explain with an example.
Appreciate your Kudos.
amitchanddak,
thank you for your reply.
Yes, the first table is a matrix.
I am adding the flag field to the columns, under the quarter column but nothing happens to the visual.
I expect to see the table as my second table in my initial message.
What am I missing?
Thanks,
vv
@vrv , have you used expand icon?
yes, I did. Thanks, it's working now!
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 | |
97 | |
82 | |
67 | |
61 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |