Forum Discussion
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.
I want it set low to high so X starts with the 0 and moves up to higher numbers as you go right.
I can't find anyway to flip it and I can't flip the sort order by clicking the visual and sorting.
Am I missing something?
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
1 Reply
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