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,

 

Could you share more details please?

1. How did you create "IsLatest" in the Query Editor?

2. Which time zone do you have?

3. Did it show expected result in the Power BI Service?

 

Best Regards,

Dale

cyan's avatar
cyan
Helper I
8 years ago

Hi v-jiascu-msft,

1) To create the IsLatest, first I converted a column that I have in my table in date-time format to Date format, then I added date filter by clicking on the button at the top right of that column > Date Filter > IsLatest.

2) My timezone is (UTC-05:00) Eastern Time (US & Canada)

3) In Power BI servie the data in the report stays in the same date as the day I published, meaning that IsLatest filter is not being applied on the report in Power BI Service, but it is applying well in the report in Power BI Desktop.

 

Is it normal that the mentioned filter is not being applied in the report on power BI service? any suggestions?

Thanks.