Forum Discussion
IsLatest date filter on a table column
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
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.
Hi v-jiascu-msft,
Do you think that the filter is desinged to work only on the local version but doesn't work when you publish to Power BI service? were you able to produce the problem?
Thanks.
Hi cyan,
I think I found the root cause. Did you set up Schedule Refresh in the Power BI Service? Or refresh the dataset manually in the Power BI Service? If you want to show up the latest data in your embedded application, you have to refresh the dataset first.
Best Regards,
Dale
Hi v-jiascu-msft,
I have scheduled refresh, plus my report is connected to the source with Direct Query, also to make sure, I did manual refresh for the dataset like you mentioned, the dataset is updated because I have other pages in the same report where I don't use the IsLatest date filter and those pages are updated but the page with IsLatest Date filter keeps showing old data.
Is the IsLatest filter working for the test report you created? are you able to see the data filtered by the latest date in Power BI Service? If it's working for you do you think it's not working for me because I am using Direct Query!!?
Thanks.