Forum Discussion
Displaying All Months on a Continuous Line Chart
Hi ArjunGrewal_
The problem in the second picture is caused by the fact that the correct sorting for the months was not defined
The months should be sorted in words according to their serial numbers as in the image below.
After that, using
"show items with no data"
Will give you the results you need.If it still does not work, please attach a PBIX
I will show you how it works on your example with a small example.If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Hi Ritaf1983
Thank you that practically solved it!
Only small issue I have now is that the months are showing as integers and not as the month names (eg. feb = 2, apr = 4, etc.)
Thanks again
Hi ArjunGrewal_
Trying to figure out where you go wrong is a bit hard for me.
I have prepared a sample file with an example for you to download:You can download a video of the work steps here:
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Super UserHi ArjunGrewal_
The problem in the second picture is caused by the fact that the correct sorting for the months was not defined
The months should be sorted in words according to their serial numbers as in the image below.
After that, using
"show items with no data"
Will give you the results you need.
If it still does not work, please attach a PBIX
I will show you how it works on your example with a small example.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Here's a photo of the correct sorting of months in words according to their number:
When I use the month name as my x-axis I still get the same result as the second image.
When I use month ID as my x-axis I get 2, 4, 6, 8, 10, and 12.
When I use the date column as my x-axis I get the same as the first image.
I believe I followed your instructions.. but if not can you clarify? Ritaf1983
- Ritaf1983
Hi ArjunGrewal_
Trying to figure out where you go wrong is a bit hard for me.
I have prepared a sample file with an example for you to download:You can download a video of the work steps here:
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
So this is what happens when I do that:
But I want the graph to be continuous like the first image in my original post. The best I could get is Mar, May, Jul, Sep, and Nov. I would be fine if I could get Feb, Apr, Jun, Aug, Oct, and Dec though.
- Ritaf1983
As you can see in the file I sent, it works perfectly.
I do not know why it works differently for you without seeing your file.
Could you please share PBIX so that I can understand what you are trying to do?