Forum Discussion
Displaying All Months on a Continuous Line Chart
Hi all,
I have a line chart that displays months Mar, May, Jul, Aug, and Nov (first image). But I would like it to display all months, and I have to use a continuous type of chart because I only have four months of data. I'm using date hierarchy and have the "show items with no data" function enabled, but it still only shows five months.
If I filter on date hierarchy by just month, it shows all months like I want it to, but the months that have data are all bunched on the right side of the graph (shown on second image).
I've been trying to figure this out for a few hours, can anyone assist me please?
Thanks
First image:
Second image:
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
12 Replies
- VahidDM
Super User
Hi ArjunGrewal_
You can remove the date from the axis and use Year and Month like this link:
https://community.powerbi.com/t5/Desktop/Show-all-months-on-graph/m-p/395521Or you can create a cutom column with MMM-YY format and use this in X-Axis.
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Hi VahidDM
I did create a custom column with MM-YYYY format and use it in x-axis, that's my first image.
The first solution doesn't work unfortunately, still shows five months.
Thanks
Tried that but my data doesn't connect like I want it to because I only have 4 months of data out of the 12. I want the x-axis to atleast be Feb, Apr, Jun, Aug, Oct, Dec.
- Ritaf1983
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
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
