Forum Discussion
Slicer issue
Hi All,
I am facing issue while trying to use one of the column as slicer.
Below is the data model structure
I wanted to use Name as slicer can some one please suggest how can we achieve this
Initially the cross filtering directin is single and then I have set to both.
I can see that the tables are connected using key so the filtering is also happening using keys
I want to use Name from Table1 and it is filtering data from Table1 correctly but data from Table3 instead of showing only
specific Names selected in slicer it is showing all the Names that are associated with that keys please see below
Can some one please suggest how to over come this scenario.
Thanks in advance
Below is the sample data
Table1
| Epic Key | Name |
| J-10 | Amanda |
| J-16 | Amanda |
| J-170 | Amanda |
| J-171 | Amanda |
| J-18 | Amanda |
| J-10 | Bruce |
| J-16 | Bruce |
| J-170 | Bruce |
| J-18 | Shin |
Table2
| Epic Key |
| J-10 |
| J-16 |
| J-170 |
| J-171 |
| J-18 |
Table3
| Epic Key | Name | Hrs |
| J-10 | Amanda | 10 |
| J-16 | Amanda | 10 |
| J-170 | Amanda | 10 |
| J-171 | Amanda | 10 |
| J-18 | Amanda | 5 |
| J-10 | Bruce | 20 |
| J-16 | Bruce | 20 |
| J-170 | Bruce | 5 |
| J-18 | Shin | 5 |
Change the filter direction back to single on both relationships then create a new dimension table for names, e.g.
Names = DISTINCT ( UNION ( DISTINCT ( 'Table 1'[Name] ), DISTINCT ( 'Table 3'[Name] ) ) )Link this new table to both table 1 and table 3 and use the column from the new table in your slicers and visuals.
3 Replies
Change the filter direction back to single on both relationships then create a new dimension table for names, e.g.
Names = DISTINCT ( UNION ( DISTINCT ( 'Table 1'[Name] ), DISTINCT ( 'Table 3'[Name] ) ) )Link this new table to both table 1 and table 3 and use the column from the new table in your slicers and visuals.