Sort By Column Multiple Charts

[Nagin]

Hi,

I have two charts which both use the 'Month' field from my date table. I require one chart to be ordered by calander year and one chart by financial year, the issue I am having is that when I apply the sorting to one chart it applies the same to the other. The charts are not synced to each other and have removed any 'edit interactions' between the two charts.

Thanks

Nagin

[Nagin]

Hi @danextian 

Thanks for reply, will create a new column

[danextian · Accepted solution]

Hi @Nagin ,

You need to have two separate month columns in your Dates table and sort them separately - either calendar or fiscal - and you use one of these coumns in one of your charts.