Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Anonymous
Not applicable

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

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!

2 REPLIES 2
v-piga-msft
Resident Rockstar
Resident Rockstar

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

 

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-piga-msft
Resident Rockstar
Resident Rockstar

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

 

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.