Change default sorting of a visual

Question

Hi everyone,I have created a calendar table (see screenshot) linked to a paramater to change the way data is displayed.&nbsp;&nbsp;With this formula, my columns "MonthYear" and "Year" are date format and "WeekYear" and "QuarterYear" text format because of the letters.&nbsp;I alredy customized a bit the formula so that my weeks can be sorted ascending without having 2005 W1, 2005 W10 and so on.&nbsp;The only problem I have now is that when I use "WeekYear" or "QuarterYear", the default sorting will be set on the Y axis resulting in not viewing the data in a chronological order:(using "YearQuarter")VS using "YearMonth"Is there a way to set or change the default sorting order of a visual?&nbsp;&nbsp;&nbsp;

anonymous · Accepted Answer

Hi&nbsp;mattcha&nbsp;&nbsp;Are you sorting your visual in ascending and descending order than for date table maybe it won't work.&nbsp;So instead of that try sorting the column "YearQuarter" and "YearMonth" using Year or Month column in the data view.&nbsp;&nbsp;For example,&nbsp;Like I was able to see Month Name in order in Data view but when i plot month name in any visual it will show in random way for that i have sorted month name column using month.&nbsp;&nbsp;Best Regards.&nbsp;If there is any post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp; to help the other members find it more quickly.If I misunderstand your needs or you still have problems on it, please feel free to let us know.&nbsp;Thanks a lot!

Forum Discussion

Change default sorting of a visual

2 Replies

Related content

Change Default Lakehouse

Sorting

Change default Lakehouse with notebookutils

Table Sort , sort order , comparer

sorting matrix