Sort by option not available in line chart

[Anonymous]

I am trying to show a count of weeks by weeks in descending order.  However, I do not get a sort option in the chart. I need to show the weeks on the x axis in descending order (10 .... 1)  Any help or guidance will be appreciated. Sample Data Images attached.

 

[Anonymous]

@Anonymous

Create a new measure for count of week numbers, then go to modelling tab and choose "sort by" to sort it by the required column,

[Anonymous]

@Anonymous

Thanks for the quick response. I assume you meant a new column measure. Can you give me the exact formula for that column? (eg: week sort = ??) 

[Anonymous]

I manually added a 2nd column to see if I could force a sort. Sorted week number by sort week. Sorted in different orders but still no luck. 

[Anonymous]

can you post an excel file with the data or power bi file and I can tell you the issue quickly.

[Anonymous]

Week descending Test File

[Anonymous · Accepted solution]

@Anonymous click on the chart and go in the visualization options in x axis, change type from continuous to categorical.

[ravaa]

Click on the chart and go in the visualization options for the x axis ,Go to Format, X-Axis, change type from continuous to categorical.

[Anonymous]

Thanks! Now I see the sort option appear.