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.
Solved! Go to Solution.
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.
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.