ISfiltered to show date selected in filter (in date format ) not true or false

[alexbalazsalex]

Dear all i would need your support for a quick formula.

I ve created a new date dable separate from my DB not to effect the results .

than i created a slicer for selecting the date ... the date selected is affecting one of my fomulas so the results has to be date format.

so in the given picture i have the date filter and i want to show instead of "True" the date selected in date format.

At the moment i used this formula and giving me True:

Month Under Analysis = ISFILTERED(Table1[Month Under Analysis])

Any Ideas ?

Thanks

[v-xjiin-msft · Accepted solution]

Hi @alexbalazsalex,

ISFILTERED() function returns TRUE when columnName is being filtered directly. If there is no filter on the column or if the filtering happens because a different column in the same table or in a related table is being filtered then the function returns FALSE. So the result will be boolean if you use ISFILTERED() function in measure.

Then if you want to get current selected Slicer value. You can use SELECTEDVALUE() function.

Thanks,
Xi Jin.

[alexbalazsalex]

Hi @v-xjiin-msft

Works Perfeclty Thank you!!!!