Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
in my table, I have 3 columns as shown below, I already set datatype's of Dataset as text, Date as date/Time and Country as Text.
Dataset Date Country
ABC 01/01/2020 00:00:00 Austria
BCD 01/01/2020 00:00:00 Belgium
CDE 02/01/2020 01:00:00 Denmark and so on.....
Later When I am trying to filter the dataset column, it gives me an error saying, [DataFormat.Error] We couldn't parse the input provided as a DateTime value. I dont understand why is this, even though the datatype of dataset is text!! It would be great if anyone can suggest anything.
TIA
Hi @Anonymous,
According to the error messages, you can check the format of Date column.
If the issue still exist, please provide more details, such as sample data, screen shots, etc.
Best Regards,
Link
Hello,
Can you please brief on the steps that you are doing when you say -trying to filter?
A screenshot would be helpful
User | Count |
---|---|
128 | |
108 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |