Forum Discussion
Silcer Issue, due to data modeling
Hi All,
I need help in fixing the issue in my visuals.
I have two table "Shp" & "Stop" and dates columns are available in both the tables.
To aviod impact of duplicate dates in both the tables i have created seperate Date table and made 1-m relationship from date table to Shp & Stop table.
Now the issue i am getting, that while using slicer from one table the visula from other table is not filtering.
below is my data model, wherein highlighted columns are available in both the table and need slicer from these column in visuals. if slicer filed taken from Shp table then the Stop table visuals not filtering as per selction.
Please help,
You can use Performance Analyzer to get a copy of the query generated for the table visual. Examining that in DAX Studio should make it clear which filters are being applied and should help you figure out why you're seeing dates you think you shouldn't.
7 Replies
You need to create dimension tables with the values for the columns you want to slice on, link them to both Shp and Stop and use them in your slicers and visuals. You can create the tables
PUD Cycle = DISTINCT ( UNION ( DISTINCT ( 'Shp'[PUD Cycle] ), DISTINCT ( 'Stop'[PUD Cycle] ) ) )I think you would need 1 table for each column you want to slice on.
like
johnt75 Hi,Thanks.
Getting the sasme result. Date filter set as 3rd Aps, but table showing all dates value of PUD rte BYAA and PUD Cycle C.Is the Date slicer coming from the Date table ? Do you only have 1 date column in each table or multiple?
