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 2...
Need Help
  • kristydanda's avatar
    kristydanda
    7 years ago

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

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!