Forum Discussion
Change Sort Order on Axis
I would like to custom sort axis and have tried creating a new table with correct values
I have used Merge Query to join the above table with the Activites Data for one to many relationship.
I read other posts suggesting to create an Index Table in Power Query but when I do that it creates a unique number for all 350 rows rather than distinct values for the 5 shown above.
A Simple workAround i can suggest is to have the index values assigned to the rows in the main table which has the data and then link the index column of both the tables . now create the chart visual and add the index column to the tooltips field and disable tooltips in the visualisation properties .
now click the menu(3 dots) on the chart visual and sort by dropdown select the index and order by ascending this should give you what you are expecting
2 Replies
A Simple workAround i can suggest is to have the index values assigned to the rows in the main table which has the data and then link the index column of both the tables . now create the chart visual and add the index column to the tooltips field and disable tooltips in the visualisation properties .
now click the menu(3 dots) on the chart visual and sort by dropdown select the index and order by ascending this should give you what you are expecting
This worked perfectly- thanks!