Forum Discussion

vgt56gyr2's avatar
vgt56gyr2
Frequent Visitor
3 years ago
Solved

dynamic custom sort on month

Hi, Problem: trying to get the x-axis column chart to dynamically sort on user selection based on date slicer --> mat, fiscal year, production year, budget... there are other periods... As of Feb, ...
Need Help
amitchandak's avatar
amitchandak
Super User
3 years ago

vgt56gyr2 , You can create a new sort column

 

if(month([Date]) <=6, month([Date]) +6, month([Date]) -6)

 

and you can mark it as sort column for MMM or MM

 

Creating Financial Calendar - From Any Month
https://community.powerbi.com/t5/Community-Blog/Creating-Financial-Calendar-Decoding-Date-and-Calendar-1-5-Power/ba-p/1187441
https://medium.com/chandakamit/cheat-sheet-calendar-of-any-standard-month-just-one-variable-apart-5ee47de6a208
https://amitchandak.medium.com/cheat-sheet-power-query-financial-year-calendar-5ceaacb520f1

vgt56gyr2's avatar
vgt56gyr2
Frequent Visitor
3 years ago

Hi, it doesn't really answer my question.

I already have a sort order column for these custom periods.

how can the axis be sorted in the correct order by user selection?