Forum Discussion
Date slicer filtering table without date
I'm facing a problem. I have table with no date, and not linked to a date table (of course) but a date slicer in the page is filtering ramdomly the data.
I couldn't imagine what it could be. Maybe a setting or software bug.
The slicer is using the date table. And the table has relations N:1 with reference tables (only one of them is related to other data table)
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.
4 Replies
- Idrissshatila
Super User
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.
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.
- Idrissshatila
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.
