Forum Discussion
Slicer Filtering
I can share some screenshots of what I mean and hope that this clears my issue up which has now worsened.
When I select the date, the data pulls through from the data source and CSV files. However, the calculated measures that have been set up with this specific table of data are now not pulling through. If you look at the MD% column on the U23 Training Report AG the columns are blank where data should appear. However, if i go to a previous date or change the report slightly, this same calculated measure now works (see U23 Training Report TG). This is the same on another one of my dashboards that uses calculated measures associated with the same table. If I go to the 31st October, the data from the calculated measures all work fine, however, if I select yesterday from the slicer, it now doesn't work (See AC pre issue and AC issue).
Finally, the date slicer works fine and I have changed the interactions, but now if I select a previous date, the subsequent dates disappear and ISlicer IssueSlicer Pre-issueAC IssueAC Pre issueU23 Training Report TGU23 Training Report AG have to close and reopen the programme to get these back.
All these issues are the same on the desktop and web version.
To resolve the issue I have tried to refresh all my data and that table in particular in both desktop and query editor and have also clear cached data via the options and settings on desktop. I have no idea why this issue has suddently started or how to resolve it.