Forum Discussion

OneWithQuestion's avatar
OneWithQuestion
Icon for Post Prodigy rankPost Prodigy
8 years ago
Solved

Clustered Column Chart: Reverse X axis?

I have a clustered column chart that is showing project priorites.   I have the priority field as a whole number in the model.   However, the X axis is high to low so priority 0 is on the right. ...
Need Help
  • MFelix's avatar
    MFelix
    8 years ago

    Hi OneWithQuestion,

     

    If you change the format of the prioratie column to text this will give you the option to sort the x-axis in the clustered column chart.

     

     

     

    If you are using the prioratie column to make some calculations and need to have it as a number a work around would be to create a dimension table for prioraties with one field as number with prioraties and a Sort column with the reverse values but formatted as text then relate the two tables and use the Sort column instead of the prioraties column on your visual.

     

    Regards,

    MFelix

     

     

MFelix's avatar
MFelix
Icon for Super User rankSuper User
8 years ago

Hi OneWithQuestion,

 

If you change the format of the prioratie column to text this will give you the option to sort the x-axis in the clustered column chart.

 

 

 

If you are using the prioratie column to make some calculations and need to have it as a number a work around would be to create a dimension table for prioraties with one field as number with prioraties and a Sort column with the reverse values but formatted as text then relate the two tables and use the Sort column instead of the prioraties column on your visual.

 

Regards,

MFelix