Visuals with relative date filters go blank/0 when uploaded to service

[Anonymous]

Hi,

I have a report with multiple visuals, some of which have different relative date filtering applied. Everything works perfectly in Power BI Desktop but once the report is uploaded to the Service it starts breaking. Visuals that don't have relative date filters still work as expected but the ones that do have them on go blank/disappear. 

Everything was working fine until a couple of days ago when made some changes to my date column in Power Query. My data is being pulled from SharePoint and the dates in SP and the dates in PBI didn't match so after some searching through the forum I went through the following steps:

• In Power Query, changed the data type to Date/Time/Timezone
• Changed time to Local Time
• Changed data type to date/time to remove the timezone

This fixed the date mismatch issue but seems to have caused this relative date filter bug to appear.

Any ideas on how to fix it?

Thanks in advance!

[v-piga-msft]

Hi @Anonymous ,

Have you solved your problem?

If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need help, please feel free to ask.

Best  Regards,

Cherry

[v-piga-msft]

Hi @Anonymous ,

Based on your description, I have made a test in the latest version of Power BI Desktop.

I cannot reproduce your issue.

Please check if you have installed the latest version of Power BI Desktop 2.68.5432.841.

In addition, if you still need help, please share a dummy pbix file which can reproduce the issue, so that we can help further investigate on it? You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.

Best Regards,

Cherry