Forum Discussion

BarnyQuack's avatar
BarnyQuack
Frequent Visitor
9 months ago
Solved

Dynamic Date Slicer

Hi, I need a date slicer to dynamically show the current month. Currently November is checked, but it needs to change to December when we get to next December and the report is refreshed. I'm sure ...
Need Help
  • danextian's avatar
    danextian
    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

     

v-hashadapu's avatar
v-hashadapu
Community Support
9 months ago

Hi BarnyQuack , Thank you for reaching out to the Microsoft Community Forum.

 

We find the answer shared by danextian  is appropriate. Can you please confirm if the solution worked for you. It will help others with similar issues find the answer easily.

 

Thank you danextian  for your valuable response.