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.
i want the below format
Current matrix report | |||||
stage 1 | stage 2 | stage 3 | stage 4 | Count | |
camp1 | 5 | 1 | 8 | 14 | |
camp2 | 1 | 1 | 1 | 1 | 4 |
camp3 | 2 | 2 | |||
camp4 | 1 | 2 | 3 | 6 | |
camp5 | 2 | 4 | 6 | ||
I want vaues of stage 3 against camp in report | |||||
stage 3 | Count | ||||
camp2 | 1 | 4 | |||
camp4 | 3 | 6 | |||
camp5 | 2 | 6 |
Solved! Go to Solution.
You can do one thing.
After Placing data on to the matric table. You go to the Visual Filter secton, there under Stage 3, select Is not blank.
You could simply ignore other stages in Matrix columns?
excludin other stages impacting the total count.
any way thanks for you though.
I see that you edited your Question. In the First version, there are blank included in the Stage3 (expecting result).
yes.. as there is no values for stage 3 i ahve removed those camps intentinally.
even if they display also no matters.
You can do one thing.
After Placing data on to the matric table. You go to the Visual Filter secton, there under Stage 3, select Is not blank.
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 |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
146 | |
110 | |
107 | |
86 | |
63 |