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.
Hello!
I am trying to summarize the information from different columns which have same descriptions.
ID A B C ....................................................... Z
1 Finished In_progress Finished Started
2 Started Started In_progress Started
3 In_progress Started Started Started
......
13452 Finished In_progress Finished ....................................... Finished
I want to have a table/Matriz that specifies how many IDs are in each step. And drill states for example if I click in A finished. That it shows me how many will be in the others.
I am trying to achieve somehing like this.
Started In_progress Finished
A 20 10 20
B 34 6 10
C 40 3 7
...........
Z 45 2 3
Is there any way without unpivotung the table and to do drill through. So, if I click on the 20. It will show me the states of the others.
Started In_progress Finished
A 20
B 4 6 10
C 10 3 7
...........
Z 15 2 3
The main goal is to have the same desctiption (Started, In_progress, finished) for all the states. (A-Z). The issue is that because they are in columns and not in row it is not easy to summarise it and by unpivot the table i lost the drill through and other characteristics of the table.
Which should be the best way to summarise it in this way without unpivot the table.
Thanks in advance.
Best.
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 |
---|---|
112 | |
97 | |
84 | |
67 | |
61 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |