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 have a slightly different and weird data configuration. I have two tables that are structured differently (shown in separate visuals on the same report) and needs to be filtered different using a single slicer as shown below:
Let's say that teams are grouped as follows:
Team A is a team on its own
Team B is composed of three teams as follows: Team C, D, E
On Table 1, data is given for each team including separate data for Team B (which is composed of C, D and E) (ignore the "Data" column as those are just arbitrary values used for illustration)
Table1
Team Name | Data |
A | 1 |
A | 2 |
B | 3 |
C | 4 |
D | 5 |
D | 4 |
E | 3 |
E | 2 |
On Table 2, data is only given for each team but not for Team B as follows:
Table 2
Team Name | Data |
A | 2 |
A | 3 |
A | 4 |
C | 2 |
D | 3 |
E | 4 |
E | 5 |
I have a multi-select slicer that lists all Teams A, B, C, D, E.
My question is, if I select Team A, C, D and/or E, I need to display and filter as usual for both tables. But if I select Team B, I need to display the Team B data (but not Teams C, D, E) from Table 1 and Teams C, D, E from Table 2. I am guessing I would need a measure for Table 2 but can't figure out how to do it. Please note that the slicer is also multi-select and there should be no duplication of data.
Basically, the slicer should work normally for Table 2 except when Team B is selected. It should also account that a multi-select or "Select All" should ignore Team B for Table 2.
I know that the data is weird but I need to work with what I have.
@ErPat , Create a new column Table 2 and join that with common team dim, Also join table 1 with common team dim
New Team = Switch(True(),
[Team] in {"C", "D", "E"}, "B",
[Team]
)
Team Dim = distinct(union(Distinct(Table1[Team]), Distinct(Table2[Team])))
Thanks @amitchandak, I tried that solution earlier but it won't show anything if I select individual Teams, ie, C, D or E. Also, I forgot to mention that there is another table relationship (Date) linked to both tables which prevents me to link both tables to the Team slicer table (would introduce ambiguity).
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 |
---|---|
96 | |
95 | |
82 | |
71 | |
64 |
User | Count |
---|---|
115 | |
105 | |
95 | |
79 | |
72 |