Forum Discussion
Date Slicer Breaks 'ALL' Measure
I have 2 measures showing the rate for crew and site. The crew measure excludes when an operator is selected and the site measure excludes when both crew and operator are selected. These measures should still be effected by all other slicers (I have a slicer for machine, date and material type as well as operator and crew).
The measures are as follows:
But my problem is that as soon as I select a timeframe, the measures break and suddenly all the filters I wanted to exclude are applied again:
Does anyone know what I'm doing wrong here?
Thanks in advance!
2 Replies
To anyone experiencing the same issue as me, I found that grouping my dates and using the grouped dates in the slicer instead fixed the issue.
I had the same issue. My data type was Datetime format for the column so if yours is also this might help:
In the query editor, I duplicated the Datetime column and changed the data type of the copy to Date since time was not needed in the slicer. Using the new column in the slicer, I no longer have the issue of application of the "between" date slicer breaking my ALL measure.
