Forum Discussion
Problem filtering by month name
Hi. I am having a very strange problem. I have a sales tracker where there are multiple tables (sales data, timesheet data, etc). All of these tables have a Month_Name column that is linked back to a Month List table. In the reports, I can then filter by Month_Name (e.g. "March 2018"). This has been working completely fine for months until all of a sudden April 2018 where nothing shows when selecting this value even though the values are definitly in the other tables. Any ideas?
I set-up a test to see what invoices show for each month selection. March works fine and shows results where in the second screenshot you can see April is blank despite seeing in the third screenshot that there is definitly data for April
7 Replies
Do you have any other filters turned on that could be affecting the results? Say a page, or report level filter?
No I already checked that - no report or page level filters are applied.
It seems to be a glitch with 01/04/18 accross the entire platform. Even when I try and filter using the exact same month name field (not the other month table) it doesn't show any results when a filter is applied - see the two screenshots. This is extremely frustrating
And just to double check, the field you are using for the slicer is exactly the same as the field used in the 3rd column of your screenshot? It's not a field with the same name in a related table?
