Forum Discussion

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?

Regular Visitor

9 years ago

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

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
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.
- v-ljerr-msft
  Microsoft Employee
  9 years ago
  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
  - Sean
    Community Champion
    9 years ago
    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.