Forum Discussion

kristydanda's avatar
kristydanda
Frequent Visitor
7 years ago
Solved

Display Slicer value dynamically on card

Hi

I have Phonelog table that have DateofRecord as a column

I use DateofRecord in Slicer.  what I want to get is when user choose As of Date in the last 20(or N number of days). I like to display 20 (or N number of days) in the card. see attached picture.

How to accomplish this?

thanks

 

 

 

Need Help
  • kristydanda's avatar
    kristydanda
    7 years ago

    thank you Lin, this works. thank you for your quick reply!

2 Replies

  • v-lili6-msft's avatar
    v-lili6-msft
    Community Support
    7 years ago

    hi, kristydanda

    If "As of Date" is a field of calendar table?

    If so, you could create a measure 

    number of days be choosed = CALCULATE(COUNTA('calendar'[As of Date]))

    then drag it into a card visual.

     

    If not, you could create a calendar table, then create a relationship with As of Date, 

    then create a measure like below:

    number of days be choosed = CALCULATE(COUNTA('calendar'[Date]))

    Then drag the field of date from calendar table into slicer and the measure into card visual.

     

    Best Regards,

    Lin

     

     

    • kristydanda's avatar
      kristydanda
      Frequent Visitor
      7 years ago

      thank you Lin, this works. thank you for your quick reply!