Forum Discussion

Bakhtawar's avatar
Bakhtawar
Post Patron
6 years ago

automatically yesterday selection

i have data field .. i drag that field in dropdown box .. so i want automtically selection on yesterday dates   means if today is march 5, 2020 .. then i want march 4, 2020 selection when ever i op...
Need Help
v-alq-msft's avatar
v-alq-msft
Community Support
6 years ago

Hi, Bakhtawar 

 

Based on your description, I created data to reproduce your scenario.

 

DateTable = CALENDAR(DATE(2020,1,1),DATE(2020,6,30))

 

 

You may create two measures as follows.

 

IsYesterday = 
IF(
    TODAY()-1 = MAX(DateTable[Date]),
    1,0
)

IsTomorrow = 
IF(
    TODAY()+1 = MAX(DateTable[Date]),
    1,0
)

 

 

Then you can create two slicers with Date column and put the measure to the corresponding visual level filter of the visual. Today is 3/6/2020. Here is the result.

 

 

Best Regards

Allan

 

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Bakhtawar's avatar
Bakhtawar
Post Patron
6 years ago

i tried your solution and it worked v-alq-msft  but i want to displayed date instead of ALL text ? is this possible .. like now ALL is dsiplayed when i opened report.. but i want to displayed date instead of ALL

 
  • v-alq-msft's avatar
    v-alq-msft
    Community Support
    6 years ago

    Hi, Bakhtawar 

     

    You need to click the icon because the slicer is dropdown type.

     

    For convenience, you may change it to 'list'.

     

    Best Regards

    Allan

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Bakhtawar's avatar
      Bakhtawar
      Post Patron
      6 years ago

      i know.. but i dont want this "ALL" text.. i want to just display date instead of ALL text.. means no need for selection/click

      v-alq-msft 

      • v-alq-msft's avatar
        v-alq-msft
        Community Support
        6 years ago

        Hi, Bakhtawar 

         

        Based on my tests, I think it is unsupported to select a value in a slicer automatically by default. The selectable value of a slicer changes with the context, but the selected value cannot be changed automatically. So you can see yesterday is selectable. However it can't be selected automatically.

         

        Best Regards

        Allan

         

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.