Date Hierarchy Drill Does Not Sort Correctly in Matrix - May 2017 Release

[Anonymous]

I haven't ran into this with other controls such as a bar chart, but when working with the Matrix and drilling into the quarters don't sort correctly and the months within the quarters don't either. 

[Anonymous]

Looks like a rookie mistake.   I did change the sort to the date column and it works.   Thanks so much for the quick response!

[v-haibl-msft · Accepted solution]

@Anonymous

Did you click the arrow icon under column header? I tested with a date column and a number column, it can sort properly as below. Do you have any sample data can be used as data source so that we can repro it easily?

 

Best Regards,
Herbert

[Anonymous]

---

@Anonymous wrote:

I haven't ran into this with other controls such as a bar chart, but when working with the Matrix and drilling into the quarters don't sort correctly and the months within the quarters don't either. 

---

This is the sample matrix.