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 created a Matrix and was wondering if it is possible to organise the 'Consultant' Column into labelled subgroups.
For example the top five consultants into a 'London Team' subgroup and a subtotal below this.
Thanks,
Henry
Hi @HenryJS ,
Do you have a "team" column/table which is related to "[Consultant]" column?
If not, you can realize that, but it's not dynamic.
If you want to create the column with DAX, it maybe be complex when you have a large amount of data.
Column =
SWITCH(
[Consultant],
"A", "London Team",
"B", "London Team",
"C", "London Team",
"D", "Paris Team",
"E", "Paris Team",
"F", "Paris Team"
)
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |