Forum Discussion
Displaying All Months on a Continuous Line Chart
- 3 years ago
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.
- 3 years ago
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
- 3 years ago
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
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
Hi ArjunGrewal_
Add that MMM-YY column as Text and sort it with oher columns, then use it 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!!