Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Change date format on charts

Hello Community,   Am facing trouble on changing the date format on 1 chart of the report am generating.   For some reason, the 1st chart you see was doable to change the date format to: DD MMM Y...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

    Please refer to my pbix file to see if it helps you.

    Create a column.

    Column = FORMAT(Targets[Date],"MMM YY")

    Then create a column to sort.

    Column 2 = year(Targets[Date])& FORMAT(Targets[Date],"MM")

    Then change the column2 type to whole number.

    Then sort column by column2.

    Best Regards

    Community Support Team _ Polly

     

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

     

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Anonymous ,

Please refer to my pbix file to see if it helps you.

Create a column.

Column = FORMAT(Targets[Date],"MMM YY")

Then create a column to sort.

Column 2 = year(Targets[Date])& FORMAT(Targets[Date],"MM")

Then change the column2 type to whole number.

Then sort column by column2.

Best Regards

Community Support Team _ Polly

 

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

 

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thank you so much, it did work!