Drill to detail showing datetime columns as integers

[philipandwaffle]

Bug description

I'm querying a CickHouse database containing datetime fields. When using a table to display the datetime columns the values are correctly rendered as dates. However, when viewing the same data by drilling to detail on a chart showing the total count the datetime columns appear as integers.

I've also ticked the "Is temporal" field on the dataset side for the appropriate columns without any effect.

Screenshots/recordings

Superset version

6.0.0

Python version

3.11

Node version

16

Browser

Chrome

Additional context

No response

Checklist

• I have searched Superset docs and Slack and didn't find a solution to my problem.
• I have searched the GitHub issue tracker and didn't find a similar bug report.
• I have checked Superset's logs for errors and if I found a relevant Python stacktrace, I included it here as text in the "additional context" section.

[venkatamandavilli-code]

Thanks for reporting this issue and documenting the reproduction steps clearly.

The behavior seems related to inconsistent handling of query context synchronization between dashboard state updates and embedded filter refresh logic. Based on the screenshots and description, it looks like the filter state may not be fully rehydrated after the dashboard reload event, which could explain why the expected filter values are not consistently applied.

It may help to verify:

• whether the filter state is preserved correctly in Redux/store updates after refresh
• whether embedded mode handles dashboard native filters differently from standard dashboard rendering
• whether the affected filters rely on async metadata loading before initialization completes

A regression test covering dashboard reload behavior with embedded/native filters might also help prevent similar issues in future releases.

Thanks again for the detailed report.