Dynamic filters has to be add in to the text box

[saiprathapdp]

Im looking to make a dynamic text box indicating what the months are for the current filter. For example, I have a last calendar month relative data filter. I need the text box to say:

The current month displayed is from 5/1/2021-5/31/2021

we have applied filters like below.

[v-xiaotang · Accepted solution]

Hi @saiprathapdp 

do you mean you want to dynamically get the value of the filters on this visual?

e.g.

if yes, I've tested and find the value can't be achieved by Allselected() function. so I think Filters on this visual won't apply filter to table, it only affect the display of the visual.

e.g.

so I suggest you to use the slicer and creat the filtermeasure or use the method mentioned by Fowmy

Best Regards,

Community Support Team _ Tang

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

[Fowmy]

@saiprathapdp 

Relative Date frilter works on the current date so you can create the following measure and use it on a card visual:

Date Period = 
    FORMAT( EOMONTH(TODAY(),-1)+1 , "dd/mm/yyyy" ) & "-" &
    FORMAT( EOMONTH(TODAY(),0), "dd/mm/yyyy" )