Forum Discussion
Dynamic Date Slicer
- 9 months ago
Hi BarnyQuack
Using Tabular Editor, you need to levareage the Group by Columns property to "store a filter by using an alternate value, which represents the key of the entity." Power BI uses this key to store the filter, allowing the corresponding filter value in the visual to change dynamically. For instance, if May-24 is selected in the visual and currently has a key of 0, when June arrives, May will shift to a key of 1, and June will take the key of 0. Please note that if you're using a dropdown, although the filters have actually changed, the slicer selection doesn't.
Further reading in the video description: https://youtu.be/MrEAZREQuXM
HI BarnyQuack , Hope you're doing okay! May we know if it worked for you, or are you still experiencing difficulties? Let us know — your feedback can really help others in the same situation.