Forum Discussion

cyan's avatar
cyan
Helper I
8 years ago

IsLatest date filter on a table column

Hello everyone,   I have applied a date filter (IsLatest) on a table column in Power BI Desktop report (through edit queries) then I published to power bi service, now the problem is that, when I o...
Need Help
v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi cyan,

 

Sorry for the late reply. The Islatest is a relative filter that means it has nothing to with with today. It filters out the latest dates of the source table. 

1. If the column contains date and time, I would suggest create a new column with pure dates.

2. Did you refresh the data in the Service?

 

Best Regards,

Dale

cyan's avatar
cyan
Helper I
8 years ago

Hi v-jiascu-msft,

 

 I did create a new column with data type as pure date and applied the IsLatest filter on it, it works on power bi desktop but in Power BI service the filter in not applying.

Also I did refresh in Power BI Service, by clicking on the refresh button on the top of the report and also I did refresh on the Dataset level in power BI Service, but the filter is still not reflecting IsLatest date.

Is there another type of refresh in the Power BI Service that I should do? 

 

Thanks.