Axis sorting not working when "Show Items with No Data" checked

[ipelly]

I have a table with some null data, and am plotting it by year/month. Even though the X axis is sorted by year / month (so 201801, 201802, etc), all the months/years with no data are coming first, even though they're later than the months/years with data. Pic attached.

[v-robertq-msft · Accepted solution]

Hi, @ipelly 

According to your description, I can understand clearly what you want to get, I think you can achieve this using another calculate column to sort the [Year month] column, you can try my steps:

1. Create two columns with the same DAX formula but different names in the data table like this:

Yearmonth = YEAR([Date])&FORMAT([Date],"mm")

Sort column = YEAR([Date])&FORMAT([Date],"mm")

Then change them to different data type, one “Whole number” and one “Text”, like this:

2. Sort the column [Yearmonth] like this:

3. Go to the line chart, sort by [Yearmonth]

And you can get what you want

You can download my test pbix file here

Thank you very much!

Best Regards,

Community Support Team _Robert Qin

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

[amitchandak]

@ipelly , just check that you have sorted on month year column using three dots