Visualization Issue

[Zaky]

Hi,

I have load the excel data with .csv file type. But when i starts creating visualisation using Smart Filter by OKViz and added Closed Date at Field, the visual shows all the closed date list as shown below.  

What i want is to have a dropdown filter like the following pic.

Is it because of format file (.csv)? But when i save the data using Microsoft Excel Workbook, i'm able to do that.

Any ideas how this can be resolved?

Regards,

Zaky

[v-danhe-msft]

Hi @Zaky ,

Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered to close this topic?

Regards,

Daniel He

[v-danhe-msft · Accepted solution]

Hi @Zaky ,

Based on my test, could you have tried with data hierarchy:

Regards,

Daniel He