Solved: Identifying date type used on relative date slicer

Anonymous · ‎06-21-2019

Is there any way to identify whether day/month/year etc. is selected when using a relative date slicer?

I'm hoping to implement this in to the Enlighten Data Story visualization. Thank you.

v-cherch-msft · ‎06-23-2019

Hi @Anonymous

You may try to use ISFILTERED function.For example:

Measure = IF(ISFILTERED(Table1[Date]),"true")

Regards,

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

View solution in original post

v-cherch-msft · ‎06-23-2019

Hi @Anonymous

You may try to use ISFILTERED function.For example:

Measure = IF(ISFILTERED(Table1[Date]),"true")

Regards,

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

Identifying date type used on relative date slicer

Helpful resources

Fabric Data Days

Power BI Monthly Update - October 2025

FabCon Atlanta 2026

How to Get Your Question Answered Quickly

Fabric Data Days starts November 4th!