Forum Discussion
Parameter bug
I managed to solve this in two ways.
In my time table I added an hourkey and in the Hour Bucket sorted by hourkeyIn the calendar table, I added a new line as Year & Month Key and I used this to sort Year & Month with the new key.
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:
- Create a measure to be used for sorting, such as
Max DateTime = MAX ( YourTable[DateTime] ) - Add this measure to the Tooltips field well.
- 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?
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.