Need to change the sort order of the KPI visualization that uses the month as the trend axis

[Anonymous]

I have a KPI visualization in Power BI Desktop that uses the month as the trend axis.
Here data is not sorted by month. I need to change the sort order of the visualization.

What should you do first?
1. Convert the visualization to a different type.
2. Remove the trend axis from the visualization.
3. Modify the visual level filters.
4. Modify the drill through filters.

[TeigeGao · Accepted solution]

Hi @Anonymous ,

In this scenario, we need to add a month number column and then order the data as the month number.

Best Regards,

Teige