Forum Discussion

ArjunGrewal_'s avatar
ArjunGrewal_
Frequent Visitor
3 years ago
Solved

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 ...
Need Help
  • Ritaf1983's avatar
    Ritaf1983
    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.

  • ArjunGrewal_'s avatar
    ArjunGrewal_
    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

  • Ritaf1983's avatar
    Ritaf1983
    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:

    Link to PBIX 

    You can download a video of the work steps here:

    Link to video 

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

Ritaf1983's avatar
Ritaf1983
Icon for Super User rankSuper User
3 years ago

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?

ArjunGrewal_'s avatar
ArjunGrewal_
Frequent Visitor
3 years ago

I can't share my file unfortunately, but it works the same as the file you sent, however the result you produced isn't exactly what I wanted. I got Jan-Dec on the x-axis as desired, but I want my points to connect to each other. My monthly data is spread out though (Feb, Aug, Oct, and Dec), so it doesn't connect.