How to sort values by 1st x axis and 2nd axis twice

[zzzsou]

Hello,

<raw data> 

Date	Part
2022	A
2022	B
2022	C
2023	A
2023	B
....

From this data table, I created bar graph( 1st x axis : date, 2nd x axis : part // Y axis : count of part)
I could sort by the first axis (date) in graph option, however I would like to sort by count of parts as well... in order to solve this issue, I added  a column with this formula below  to sort part coulmn with this formula but Cyclic dependencies error poped up.

count_part =
CALCULATE(
COUNT('table'[Part]),
FILTER('table',
'table'[Part]=EARLIER('table'[Part])
)
)

could you kindly help this issue please?

[Arul]

@zzzsou ,

If you want to make sorting at this level you have to change year column to text if it is having only numbers and also I am not sure whether you used sort option in next level.

Thanks,

Arul