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    
Need Help
  • rajendraongole1's avatar
    rajendraongole1
    2 years ago

    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!!

rajendraongole1's avatar
rajendraongole1
Super User
2 years ago

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!!