Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hello, everyone,
I would like to draw a line-graph to compare sales between different years. The data concern a seasonal product, which only has a market in September, October and November.
Since sales are not made every day, the graph is not a continuous line, but has jumps.
I would like to obtain a continuous line.
I have followed this guide https://community.powerbi.com/t5/Desktop/Unable-to-change-x-axis-type-from-categorical-to-continous-...
but the problem is that PowerBI does NOT let me switch the line type from "CATEGORICAL" to "CONTINUOUS".
Attached here is a copy of the file and video showing the problem.
Video of the problem
https://1drv.ms/v/s!AhGat32AjfJJgeU9hGGLOvhU5h39tA?e=PcnUNQ
File .pbix
Hello everyone
I solved this problem by duplicating the date field and applying a day-MonthName format
Best regards
JM
Thank you very much! This worked perfectly!
@Rusciano if i understand correctly, than you only need another "self made" table in Data input. In this table you simply create a rank for Jan to December and than you go to "Data" and you click on the monthname column and saying that this column should be "sort after" the numbers. Because number asc will put the monthname into right order. You can also do the same for Year Monthname. Alternatively you can do that in Powerquery.
Hello, thanks for your kindly reply.
I am not sure to understand how to solve the problem. I created a new column named "month number", defining a range-order from 1 to 12. Then I replaced the x-axis category "date-month" with the new column "month number" and, finally, I sorted x-axis by the latter.
However I does not work, I cannot change x-axis from categorial to continous. 😭
Attached to my post there a very simple .pbix which figures out my problem. Could you help me downloading the file to check why i does not wok ?
Thanks a lot!!
Ciao @Rusciano, please check here:
https://drive.google.com/file/d/1bHS5dQDoIbfYQJDPA3QgGYwRVMzPjqy-/view?usp=sharing
You have limited data for that time frame, but now you can see the graph and in "categorical" format.
Best.
User | Count |
---|---|
120 | |
65 | |
62 | |
56 | |
50 |
User | Count |
---|---|
177 | |
85 | |
70 | |
63 | |
55 |