Forum Discussion
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?
Hi madden318,
You should be able to use BLANK Function (DAX) 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] )
Regards
I am typing this on an iPad and have not tested this so this is just a guess...
However I suspect your Calendar table runs till the end of the current year if not beyond...
so try adding a FILTER statement in the Measure you are charting to only calculate till today
something like this...
Measure = CALCULATE ( SUM (...), FILTER ( ALLSELECTED ( 'Calendar' ), 'Calendar'[Date] <= TODAY () )
Again I have not tested this - just a suggestion.