cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kristydanda Frequent Visitor
Frequent Visitor

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

 

 

Capture.PNG

 

1 ACCEPTED SOLUTION

Accepted Solutions
kristydanda Frequent Visitor
Frequent Visitor

Re: Display Slicer value dynamically on card

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

2 REPLIES 2
Community Support Team
Community Support Team

Re: Display Slicer value dynamically on card

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.

6.JPG

 

Best Regards,

Lin

 

 

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
kristydanda Frequent Visitor
Frequent Visitor

Re: Display Slicer value dynamically on card

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