we are not getting the relative date filtering

[surya2pir]

Hi Team,

we are not getting the relative date filtering inside the visual level filter when we are trying to fetch insightly data inside the power bi pro.

Please let us know how to get currently we are only able to get basic and advanced filters.

[v-qiuyu-msft]

Hi @surya2pir,

1. Please check if the column field which you want to use Relative date filtering hit this limitation. 

2. Which insightly data do you mean? Are you able to use Relative date filtering for date column in other reports? 

Best Regards,
Qiuyun Yu

[surya2pir]

Hi @Qiuyun,

Thanks for your reply.

We are using App Power Bi not desktop Power Bi. For your reference, we have attached two screenshots in the first one we are able to get relative data filtering and the second one that is basically for insightly data report here we are not able to get the relative data filtering. Help us to resolve this asap

[v-qiuyu-msft]

Hi @surya2pir,

Please check if the column DATE_CREATED is Date type. You can use Advanced Filtering, if the calendar is available the the type should be date. 

 

You can also create a slicer visual, drag the column DATE_CREATED to slicer, check if the Relative mode is available. 

Best Regards,
Qiuyun Yu