Slicer Filtering

[Frasermc98]

Hi, 

I have a slicer filter for age group on several of my dashboards. However, now when i select the U15 age group i can no longer select any date on my other slicer except for the one that was selected when I 1st selected U15. The data for that day still appears but any calculated measures also on my dashboard now don't appear. On the same slicer if I was to select any other higher age group such as U16 or U18 it all works fine again. It is just age groups at U15 or lower. There isn't any differences in my raw data files compared to how it usually pulls through to powerbi. I have no idea what the issue is or why this has occurred so any help someone could provide me with would be greatly appreciated. 

Thank you. 

[Frasermc98]

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. 

[ray_aramburo]

Click on the Age slicer, go to Edit interactions and restrict the interaction from that slicer to the date slicer by clicking on the Forbid Icon in the date slicer. Then, click on Edit Interactions again to close it. 

[Frasermc98]

Hi, 

Thank you for your response. This solved the date slicer issues but the calculated measures associated with this specific U15 selection are still not working on the visuals. I haven't changed anything with my raw data and as i said, the other age groups I select on the slicer still show the calculated measures. This was never an issue previously, I opened my report yesterday morning and the issue had started. I've tried updating the app but that hasn't worked. 

[ray_aramburo]

Is it possible for you to share a sample of your data or your .pbix file?