Line graph - Line continues for months with no data

Question

Have an issue with a line chart showing multiple lines each representing a year. &nbsp;2016 line continues even though there is no data for november and december. &nbsp;How can i get rid of this?

alanhodgson · Answer

Hey madden318,&nbsp;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.&nbsp;Hope this helps,&nbsp;Alan

madden318 · Answer

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

alanhodgson · Answer

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 · Answer

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

v-ljerr-msft · Answer

Hi&nbsp;madden318,&nbsp;You should be able to use BLANK Function (DAX)&nbsp;to skip the value 0 in this scenario. For example, if you are showing "Total Sales" on the Line Chart.Total Sales = SUM ( Sales[Revenue] )Then you should be able to show the following measure instead on the Line Chart to skip the value 0.Measure = IF ( [Total Sales] = 0, BLANK (), [Total Sales] )&nbsp;Regards

Forum Discussion

Line graph - Line continues for months with no data

6 Replies

Related content

Group By not continuously applying

Displaying All Months on a Continuous Line Chart

problem with line graph for continuous totals

I need continuous months for the project

Month/Year under chart/graph