Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Format error in date when publish

Hi , 

I have a problem after publish the dash in the filter zone (Slicer) .

The Date format is like mm/dd/yyyy (wrong format) but in all Dash the format is correct dd/mm/yyyy . 

 

I did all modifcation but still remain the problem.

Please tell me if you know the solution.

 

Br

Carlos

Need Help
  • v-xiaotang's avatar
    v-xiaotang
    4 years ago

    Hi Anonymous 

    Thanks for reaching out to us.

    Is the column in correct format before you selections in slicer? If so, try this, 

    (1) change the format first

     

    (2)  if (1) is not helpful, please go to Power Query Editor, then check the date format in the two steps of source and changed type to confirm whether the date format obtained in the changed type step is correct, if not, try this,

    Best Regards,

    Community Support Team _Tang

    If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

1 Reply

  • v-xiaotang's avatar
    v-xiaotang
    Community Support
    4 years ago

    Hi Anonymous 

    Thanks for reaching out to us.

    Is the column in correct format before you selections in slicer? If so, try this, 

    (1) change the format first

     

    (2)  if (1) is not helpful, please go to Power Query Editor, then check the date format in the two steps of source and changed type to confirm whether the date format obtained in the changed type step is correct, if not, try this,

    Best Regards,

    Community Support Team _Tang

    If this post helps, please consider Accept it as the solution to help the other members find it more quickly.