cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
KhalenG
New Member

Date stopped properly filtering one of my data tables

Not sure how this is possible, or what changed, or how to fix this.

I have an executive dashboard with various other data tables (guest feedback, quality scores, HSE scores). These all worked as expected for 5 months. 

I checked it today and the Guest feedback no longer filters. Digging deeper, it only shows values when the date slicers are set to (Blank). I've tried resetting the relationships, I've confirmed the data types are dates both ways. Im at a loss and need guidance on how to troubleshoot this.

1 ACCEPTED SOLUTION
KhalenG
New Member

Welp, resolved this. Going to share this in case anyone else comes across this. 

The data was linked to a Smartsheet, and I imagine something changed on the import to include Time + Timezone. Not sure why, but the time + timezone part was breaking everything. I extracted the date (got rid of timezone and time) and everything is working again as expected.

View solution in original post

1 REPLY 1
KhalenG
New Member

Welp, resolved this. Going to share this in case anyone else comes across this. 

The data was linked to a Smartsheet, and I imagine something changed on the import to include Time + Timezone. Not sure why, but the time + timezone part was breaking everything. I extracted the date (got rid of timezone and time) and everything is working again as expected.

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors