Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Listers,
If I have a calendar column of format such as "mmm-yyyy" and want to display my values in a line chart, how do I sort the calendar for the line chart x-axis to display Jan 2020, Feb 2020 ...... Dec 2020 and then Jan 2020 etc?
TIA John
Solved! Go to Solution.
You need to create another column, either in your source data or in Power Query, that would be the year * 100 + the month, so it would be 202001, 202002, 202003, etc. Then you would sort your axis column above by this column. Sort by column in Power BI Desktop - Power BI | Microsoft Docs has detailed info. My date table at https://bit.ly/DateTableByEd is built in Power Query and has several columns used exclusively for sorting other columns.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingYou need to create another column, either in your source data or in Power Query, that would be the year * 100 + the month, so it would be 202001, 202002, 202003, etc. Then you would sort your axis column above by this column. Sort by column in Power BI Desktop - Power BI | Microsoft Docs has detailed info. My date table at https://bit.ly/DateTableByEd is built in Power Query and has several columns used exclusively for sorting other columns.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingEdhans, Thnx heaps
worked a treat
Rgds
Great @jmaikido - I hope you don't mind. I marked my answer as the solution so others that view this thread can quickly see how to get it to work.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingUser | Count |
---|---|
97 | |
85 | |
77 | |
66 | |
62 |
User | Count |
---|---|
110 | |
96 | |
95 | |
64 | |
57 |