Forum Discussion
Date Slicer Not Working
HI Telenar,
Did you mean to add a date field to your 'between' mode slicer and it will switch to hierarchy mode instead of common date slicers?
If that is the case, I think it may be related to the date hierarchy. Power bi may add optimization with this scenario(add the same date field multiple times to the same slicer) and will try to analyze and convert them to the different granularity of hierarchy levels.
You can also right-click on the current hierarchy slicer date field to convert date field to common mode to restore the default slicer.
Regards,
Xiaoxin Sheng
Ok so confused but found a work around. If I drop the date in and then change it to a slicer I get the above behavior. If on the other hand I create an empty slicer and then drop the date on it, it works just fine. So I have a work around, but still would love to know why the old way (drop date in and change to slicer) no longer seems to work.
HI Telenar,
Did you mean to add a date field to your 'between' mode slicer and it will switch to hierarchy mode instead of common date slicers?
If that is the case, I think it may be related to the date hierarchy. Power bi may add optimization with this scenario(add the same date field multiple times to the same slicer) and will try to analyze and convert them to the different granularity of hierarchy levels.
You can also right-click on the current hierarchy slicer date field to convert date field to common mode to restore the default slicer.
Regards,
Xiaoxin Sheng