Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I would need an advice please, when I put Months on the X-axis, they don't logically follow from January, through February, etc. to December (from left to right on the X-axis of the graph). How can I organize it?
Solved! Go to Solution.
First, you need an additional column in your date table to display the month number. You can either create this in Power Query beforehand or after loading your table with something similar to MonthNumber = CONCATENATE ( YEAR ( date[date] ), MONTH ( date[date] ) ). Then you can select your Month column and go to modeling options. There you can use sort by to sort your months by month number. Here is a blog post with more info on this:
You have to create a sorting column in the table and use that as a sort column. The option is there when the view table in Data mode under the modeling tab.
You can use code to create a sort column from date
Sort of Month = format(date,"YYYYMM")
Hi @MonikaS ,
The month name is text type which is not suitable for sorting. You can use SWITCH() or FORMAT() function to get whole number type which is easier and more suitable for sorting.
You have to create a sorting column in the table and use that as a sort column. The option is there when the view table in Data mode under the modeling tab.
You can use code to create a sort column from date
Sort of Month = format(date,"YYYYMM")
First, you need an additional column in your date table to display the month number. You can either create this in Power Query beforehand or after loading your table with something similar to MonthNumber = CONCATENATE ( YEAR ( date[date] ), MONTH ( date[date] ) ). Then you can select your Month column and go to modeling options. There you can use sort by to sort your months by month number. Here is a blog post with more info on this:
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |