Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to Solution.
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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCovering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |