Parameter bug

[SC07]

Field parameter set up here using Year & Month and Hour. Both of these are from a table built using DAX. 

Currently you can see that Y&M runs in sequence November to May, but then when I switch to Hour, the sort changes to total and switching back to Y&M also changes the sort from sequence in month to high to low. 

Anyone know how to fix this?

[OwenAuger]

HI @SC07 

This is indeed an annoying side effect of using a field parameter to select the field(s) used on an axis.

The "Sort axis"settings for the chart unfortunately reset whenever the field is changed.

One fix I have applied in the past is to:

1. Create a measure to be used for sorting, such as Max DateTime = MAX ( YourTable[DateTime] )
2. Add this measure to the Tooltips field well.
3. Set "Sort axis" to this measure ascending.

Do Month and HourBucket come from the same calculated table you mentioned? If so, it should be straightforward to create an appropriate measure.

I realise that adding the measure as a Tooltip field may "disrupt" the tooltip, in which case you could either disable tooltips or use a report page tooltip.

Does something like this work for you?

[SC07 · Accepted solution]

I managed to solve this in two ways. 
In my time table I added an hourkey and in the Hour Bucket sorted by hourkey 

In the calendar table, I added a new line as Year & Month Key and I used this to sort Year & Month with the new key.