Forum Discussion
Helper Idouble-clicking a date resets date filter
Hi, need your expertise please. We have imported data from Jan to March. I've set the table.date to start from March to hopefully exclude all data before it from the filter using this formula (Table.Date = ADDCOLUMNS(CALENDAR(DATE(2020,3,1), DATE(2025,12,31)), "DateOnly", FORMAT([Date],"DD/MM/YYYY")). However, when the date from the slicer is selected/clicked twice (for example 9), it does not filter anymore and returns all computations from January. I guess it resets the selection somewhat, maybe? The user has to be very careful to click the dates only once for the report to return the correct result. Does anyone know why and how to solve this bug? Maybe there is another way to filter the data instead?
I have a few measures created in reason table which is directly linked to the date filter (Table.Date[Date]). I've also got an inactive relationship between date and data tables to obtain some computation/measure for data table. There is a direct relationship between data and reason tables through field ID. Please help? Thank you.
Hey e_vera
inside Power Query,
mark the query (the table that contains the January/February data)
mark the column and apply a proper filter
Maybe you want to check this site: https://docs.microsoft.com/en-us/power-bi/ and have a closer look at the the section "Transform and shape data".
Hopefully, this provides the missing link.
Regards,
Tom
3 Replies
- TomMartens
Super User
Hey e_vera ,
can you please explain why you imported January/February data but, now you want to exclude it.
The most consistent way would be not to import the data or filtering dates that are greater than 29th of February 2020, using Power Query.
The date picker is not restricted to available dates, maybe you create an idea at ideas.powerbi.com
Regards,
Tom
e_veraHi Tom,
Thank you for your suggestion. I tried to filter from Get Data but couldn't get it to work based on date on multiple tables using the SQL statement for postgres. Would you be able to guide me how to filter from Power Query?
PS. I have zero idea on this, so a detailed guide is much appreciated. Thank you.
- TomMartens
Hey e_vera
inside Power Query,
mark the query (the table that contains the January/February data)
mark the column and apply a proper filter
Maybe you want to check this site: https://docs.microsoft.com/en-us/power-bi/ and have a closer look at the the section "Transform and shape data".
Hopefully, this provides the missing link.
Regards,
Tom