Forum Discussion
Parameter bug
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?
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.
2 Replies
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 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.
- Create a measure to be used for sorting, such as
