Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Date Table

i Have created Date table i used Date quarter column to create slicer

 

I choose 2015 q1,2015q2 But getting error

Please provide solution

 

 

  • Hi Anonymous - Make sure that there are no invalid or incorrectly formatted date values in your data. For example, ensure there are no dates like 2023-02-30or non-date strings in date fields.

    You can also check the locale settings can affect date parsing. Ensure that the locale settings in Power BI match the date formats in your data source.

    Date-Quarter, can you change the datatype to Text format? instead of ABC123. 

     

    Did I answer your question? Mark my post as a solution! This will help others on the forum!
    Appreciate your Kudos!!

1 Reply

  • Hi Anonymous - Make sure that there are no invalid or incorrectly formatted date values in your data. For example, ensure there are no dates like 2023-02-30or non-date strings in date fields.

    You can also check the locale settings can affect date parsing. Ensure that the locale settings in Power BI match the date formats in your data source.

    Date-Quarter, can you change the datatype to Text format? instead of ABC123. 

     

    Did I answer your question? Mark my post as a solution! This will help others on the forum!
    Appreciate your Kudos!!