Sort order with hierarchy as axis when drilling down

[Anonymous]

I have a reference table used for financial periods; week, month, quarter and year (note specifically not date). I've created this as a hierarchy, linked it to my main tables, on the week number and added it as the axis on a stacked bar chart.

I want this sorted so that the order is Latest to Oldest (ie Descending) in my stacked bar chart. Which works fine when set at one level in the hierarchy - as soon as I drill this down to the next level, the sort order changes. I thought it would be easy enough to set the sort order at each level and it would be retained, but it's not.

I have already set the relevant sort by columns in the table view for both the reference and data tables and it has no influence.

Any ideas on how I can keep the sort order in the order that I set?

All support welcome, this has been driving me mad for days.

[Seward12533]

Yea. Few things you can try - check to see if you need to change the axis sort options.

See this answer to the bug report I submitted on this.
https://community.powerbi.com/t5/Desktop/Sorting-on-a-combo-chart-with-new-release/td-p/483134

If that does not work try using the text Value ow the week or month number use FORMAT to create new column in your date table.

[Anonymous]

Hi there,

None of these have worked. I've set every value to text, but the ability to change the data type to categorical for the axis doesn't appear in a stacked bar chart.

using FORMAT creates a nice column, but it still won't retain the sort when drilling up or down the heirarchy in the visual, always reverting to the default ascending sort order, and normally changing the sort order to the other axis.

Is this a bug?