Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
I am using a line and clustered column chart and I want to display the last 12 months of the values I am analysing. I have set the date filter to show the relative date in the last 1 years within the filter column, whereby the dates assessed are saying the correct dates (07/05/21 - 06/05/22) and the chart below is showing the correct values for those months, but they are out of order. This graph is showing Jan-Apr 2022 with the following columns being May-Dec 2021.
If DAX is needed, my date variable is 'Proposal Sent Date', with the column y-axis as 'Gross Value' and line y-axis is 'count of Gross Value', thanks!
Solved! Go to Solution.
Hi @Anonymous
If you don't want to use a date table then you need create a Month Number and Month Name columns
Month Number = MONTH ( Table[Date] )
Month Name = FORMAT ( DATE ( 1, MONTH ( Table[Date] ), 1 ), "MMMM" )
You can use the "Sort By" the sort the month name based on month number.
You can also create a date hierarchy as shown in the following screenshot
Hi @Anonymous
If you don't want to use a date table then you need create a Month Number and Month Name columns
Month Number = MONTH ( Table[Date] )
Month Name = FORMAT ( DATE ( 1, MONTH ( Table[Date] ), 1 ), "MMMM" )
You can use the "Sort By" the sort the month name based on month number.
You can also create a date hierarchy as shown in the following screenshot
User | Count |
---|---|
66 | |
46 | |
20 | |
19 | |
15 |
User | Count |
---|---|
121 | |
41 | |
38 | |
28 | |
23 |