Forum Discussion

nranito's avatar
nranito
Helper II
8 years ago
Solved

Date Slicer - Default value

I have a dashboard with a Slicer, which contains a date field. The slicer is configured as Between.

 

The dashbboard is refreshed every day.

 

I would like the slicer, each day, to have the interval Today and Today - 10 days (for example).

Of course, the slicer must continue to be edited.

 

Can this be acomplished?

 

Thank you for any help

 

 

 

Need Help

9 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Did you find a solution ? I am now trying to do the same thing . 

      Would be very helpful if you could share your solution . 

      Thank you in advance !

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Anonymous : did you find the solution i am also doing the same

  • jthomson's avatar
    jthomson
    Solution Sage
    8 years ago

    One approach might be to make a custom calendar table that pulls today's date as the end point and today's date -10 as the start point and then relate that to your main calendar?

    • nranito's avatar
      nranito
      Helper II
      8 years ago

      But can I still change the calendar like that?

      Because I want those as default, but still want to maintain chance of choosing any random dates outside that range

      • jthomson's avatar
        jthomson
        Solution Sage
        8 years ago

        Ah, I see what you mean now, that's not going to work for what you want

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support
    8 years ago

    Hi nranito ,

     

    So your requirement is to create a dynamic calculate date column between today and 10 days previous, then create a slicer chart based on the column, right? If it is, I'm afraid power bi doesn't support dynamic calculate column. In addtion, you can submit your  idea about improvement of slicer chart here: https://ideas.powerbi.com.

     

    Regards,

    Jimmy Tao

    • nranito's avatar
      nranito
      Helper II
      8 years ago

      I have a table with dates.

      Let's say a year

      My slicer must choose an interval inside that year

       

      What I want is to be started with a default value (interval)