Forum Discussion
Date slicer filtering table without date
- 1 year ago
Hello Rodrigo_Cruz ,
does any of the relationships coming to table 2, are being filtered by the date table.
because it can and it is logically that one of these two tables coming into table 2 are linked to the date table.
and this is the reason its being filtered.
Hello Rodrigo_Cruz ,
maybe the date table is connected to a table that this table is connected to the table that the data is changing in.
- Rodrigo_Cruz1 year agoNew Member
Look, the number 1 is the date table and the number 2 is the data I'm handling.
There's no both directions relationship in the board.
The third table in this pic is connected to another date table. But, independently of this, the data in the Proj_geral table is not about any type of time, there isn't an insertion, or modification time, even date, furthermore all content is collected from an excel file and is handle by Power Query at same time, and only part of the content appears when I filter, using a date slicer (of #1 table - date table), the year 2025, if I choose 2024 all of the items appears.
- Idrissshatila1 year agoSuper User
Hello Rodrigo_Cruz ,
does any of the relationships coming to table 2, are being filtered by the date table.
because it can and it is logically that one of these two tables coming into table 2 are linked to the date table.
and this is the reason its being filtered.
- Rodrigo_Cruz1 year agoNew Member
After your message, I rechecked the relationships, and I found one relationship in both directions connected to a table linke to date table. When I changed to single direction the problem solved.