Changed the order of filter pane for Play Axis

[Anonymous]

Good day everyone, i am playing with Play Axis now (it can auto filter the chart one by one by auto check the filter). I would like to filter the month by Septermber follow by October , November and December. Unfortunately current default of filter is according to ascending order. Anyone know how to edit the order of filtering in Play Axis?

[v-shex-msft]

Hi @Anonymous,

I'd like to suggest you take a look at the following blog to create a sorting table and mapping to the raw table field to apply custom sort order based on the 'sort by column' property:

Custom Sorting in Power BI 

Regards,
Xiaoxin Sheng

[amitchandak · Accepted solution]

@Anonymous , You need create month year sort column and mark that as sort column

New column

Month Year sort = FORMAT([Date],"yyyymm") //Mark this as sort column of you month year

or Month Year sort =

if(month([Date]) <=8, (YEAR([Date]) -1)*100 + month([Date]) +4, (YEAR([Date]) )*100 + month([Date]) -8)

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