Reorder x axis not by name

Hi @Philipp,

Each dimension and each hierarchy within a dimension has its order of members.
For version related dimension Fix Version and Affects Version is three hierarchies:

  • Default hierarchy: versions are ordered first by project, then by status and only then by name alphabetically
  • Hierarchy by name: where versions are ordered alphabetically by name.
  • Hierarchy by status: where versions are ordered first by status, then by project and then by name alphabetically.

Another option to order versions is to create a new calculated member in dimension Fix Version (or dimension Affects Version if that is on rows) and define order by some version property, like, Start date or Release date.
Please visit community post on this topic how to change row order with a calculated member: How to change order of columns and rows in the report?

For example, to order all fix version by release date, a formula for a calculated member may look like this:

Aggregate({
 Order(
  [Fix Version].[Version].Members,
  [Fix Version].CurrentMember.get('Release date'),
  BASC)
})

More information on calculated members is in the documentation: https://docs.eazybi.com/eazybijira/analyze-and-visualize/calculated-members

Best,
Zane / support@eazyBI.com