Is there a functionality wherein I can arrange the Filter Values in a particular order?
I have a chart with a Hierarchy Value filter. The Hierarchy in the chart has been sorted manually. But, the filter still shows the values in Alphabetical order only.
Hi Ravi,
The Filter controls automatically sort alphabetically as you describe. Why would you want it in a different order?
The only use case that i can foresee is where you might want to have certainly common values at the top for easy selection.
Hi Jeff,
We want to offer the values in the descending order of their value to the user.
Hi Ravi
We need to do that as well sometimes, e.g. ‘Male’ before ‘Female’.
I think the only way to do it at the moment is to have a Hierarchy which is sorted and apply that to the column that you are using in the filter.
Hi David,
I already have the Hierarchy sorted in the Chart but that doesn’t affect the Value Filter sorting.
Hi Ravi,
The sorting in the chart won’t matter but you can change the sorting by using a full hierarchy.
Instead of using the data directly from your data source, go ahead and first create a hierarchy and apply the sorting there.
Hi Ravi
Do you have a Hierarchy object (the orange things under ‘data cubes’ in the explore panel)?
Sorting the chart won’t help, but sorting a Hierarchy object and then applying that in the data cube will.
