Sort by quarter dates

[joao_costa]

Hi,

I have a master table containing transactional data that I then group by quarter and display in a bar and line chart.

My goal is to display the data having the quarter dates (start/ end) in the x-axis, however even after trying sorting and creating a support table to link with the master for the purpose of sorting, it doesn't seem to work.

Any ideas on why?

Thank you

This is my sorting table

This is the chart I get

[Anonymous · Accepted solution]

Hi @joao_costa ,

Add the index column to tooltips field then you could sort the visual by index directly.

Best Regards,

Jay

[amitchandak]

@joao_costa , Make sure  index is marked as the sort column of Quarter Month

and visual is sort on Quarter Month

How to Create Sort Column and Solve Related Errors: https://www.youtube.com/watch?v=KK1zu4MBb-c

[joao_costa]

Yes that's correct, all sorted as mentioned