Forum Discussion

madden318's avatar
madden318
Regular Visitor
9 years ago

Line graph - Line continues for months with no data

Have an issue with a line chart showing multiple lines each representing a year.  2016 line continues even though there is no data for november and december.  How can i get rid of this?
Need Help
alanhodgson's avatar
alanhodgson
Solution Supplier
9 years ago

Hey madden318,

 

Easy fix, go to the paint roll "Format" tab and under the "X-Axis" dropdown, change the type to "Categorical" instead of "Continuous". This should stop the graph at the last point.

 

Hope this helps,

 

Alan

  • madden318's avatar
    madden318
    Regular Visitor
    9 years ago

    Thanks Alan but it is already on the categorical setting.  Has this ever fixed it for you?

    • alanhodgson's avatar
      alanhodgson
      Solution Supplier
      9 years ago
      That works for me. It looks like PBI is defaulting your data for 2016 in the last 2 months to zero. Does it do the same thing for other types of graphs or is it just the line graph?
      • madden318's avatar
        madden318
        Regular Visitor
        9 years ago

        Yes it is definitley adding 0 values into may data where there is none.  Tried switching it to a line and stacked volume chart and it did the same thing.