E
E
Evkor2021-12-01 08:49:44
excel
Evkor, 2021-12-01 08:49:44

How to build a graph in power bi by months in chronological order?

I can’t figure out how to make a graph so that the months are displayed in order, and not alphabetically. I want to see on the graph data for several years by months in chronological order. Below I apply the formula by which I made the calendar table and the screenshots of the chart in its current form, the calendar table itself and which columns I build.
Calendar =
ADDCOLUMNS (
FILTER (
CALENDARAUTO ( ),
YEAR ( [Date] ) >= 2010 &&
[Date] <= today()
),
"DateAsInteger", FORMAT ( [Date], "YYYYMMDD" ),
"Year", YEAR ( [Date] ),
"Monthnumber", FORMAT ( [Date], "MM" ),
"MonthYear", FORMAT ( [Date], "mmm/YYYY" ),
"Month", FORMAT ( [Date], "
"WeekNumber", WEEKNUM([Date],2),
"MonthNameLong", FORMAT ( [Date], "mmmm" ),
"DayOfWeekNumber", WEEKDAY ( [Date] ),
"Day", FORMAT ( [Date], "dd" ),
"DayOfWeekShort", FORMAT ( [Date], "ddd" ),
"Quarter", "Q" & FORMAT ( [Date], "Q" ),
"Month Sorter", FORMAT ( [Date], " YYYY" ) & FORMAT ( [Date], "MM" ),
"Week Sorter", FORMAT ( [Date], "YYYY" ) + WEEKNUM([Date],2)/100)

61a709af42219933459570.png Below is the sample graph as it should look. I searched the whole example and I can’t understand why it’s not built the same way for me. The data is the same
61a70b6066d00575177817.png

src=" https://habrastorage.61a70ba8d1588170554365.png
61a70cad24d23914540751.png

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question