Forum Discussion
Sort On base of filter selection
Hi Phil,
If I have an dynamic X axis say If i select Daily its should chnage to Day level, Monthly then Month Level. So far it works fine if I am on daily but moment I click on weekly the month names are sorted alphabatically. So I cerated another small table to sort with Month Names and their Ids as 1,2,3, for Jan, Feb, Mar and so on and put sorting on Month ID but still not working.
My X Axis formula is like
SortedXAxis = if(Period[SelectedPeriod]="Monthly",InventoryReporting[MonthName],if(Period[SelectedPeriod]="Weekly",format(InventoryReporting[WEEK_END_DATE],"MM/DD/YYYY"),format(InventoryReporting[Snapshot Date],"MM/DD/YYYY")))
where when I click on Monthly in filter below it gives me data but MOnth Name is sorted alphabatically as below whiel I want to sort it by its sequence. This is bit different than usual
7 Replies
HI Anonymous,
If you create a custom sorting table and set up 'sort by column' property, you need to create relationship to original table and use this custom table column to replace original column to create visualization to apply custom sort effect.
BTW, it will be help if you share some sample data or pbix file.
Regards,
Xiaoxin Sheng