Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, my x-axis is alphabetical. However, I'd like to move "FF" to the end. Is there a way to do that?
Try this:
Edit sheet- select your bar chart -> sorting
You will find your measure down below the dimension -> move the measure to the top
then sort numerically -> Ascending
Unfortunately that did not work. I have one dimension and two measures. I went to 'Sorting' and moved the measures above dimension and then tried Sorting numerically. Now the order is rather messesd up.
Under Sorting:
Move the Dimension up the order(above measures)
Enable Sorting Only on the Dimension
Disable sorting on both the measures
You can also define custom sorting using a measure expression
choose sort by Expression on the Dimension and try below expression
=Wildmatch(FieldName,'r1','r2','r3','ff')