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 the following problem.
I have a dashboard with several charts that contain various calculations.
I would like to place a selector from a group of items in a dimension.
For example:
Item
A
B
C
D
E
I would like to group it like this:
Group 1 = A, B
Group 2 = A, B, C
Group 3 = D, E
Group 4 = A, B, C, D, E
That way I would like the selector to have the items grouped together.
And when choosing one of these groups, the entire dashboard would show the calculations based on that item group.
Thanks.
Solved! Go to Solution.
You would need to create a table similar to this:
And then add the grouping to your slicer to be able to get the calculations for these groups, and then of course, create a relationship back to your base table where you're getting the item id/name from.
You would need to create a table similar to this:
And then add the grouping to your slicer to be able to get the calculations for these groups, and then of course, create a relationship back to your base table where you're getting the item id/name from.
@waltersbrf , You have to create one more table with multiple groups and need to have many to many join with that
Group item
1 A
1 B
2 A
And so on
Something similar done in this video - Single Select with Select All : https://youtu.be/plGqCEZRfXU
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 |
---|---|
110 | |
96 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |