cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
GovindM
Helper I
Helper I

DataFormatError

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

 

2 REPLIES 2
v-xulin-mstf
Community Support
Community Support

Hi @GovindM,

 

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

PC2790
Impactful Individual
Impactful Individual

Hello,

 

Can you please brief on the steps that you are doing when you say -trying to filter?

A screenshot would be helpful

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.