Forum Discussion
Show zero on Line chart where no data for date
Anonymous
Ok, here is a true and tested way:
Create a measure along the lines of:
Cutoff = VAR _MaxDataDate = CALCULATE(MAX('Audits'[ShiftDate]), ALL('Audits')) RETURN IF(MAX('Calendar'[Date]) <= _MaxDataDate, 1)Now select the visual and add this measure to the "Filters on this visual" in the filter pane and set the value to 1.
Use the proven [AuditCount] measure in the visual:
PaulDBrown as a follow-up to my reply yesterday, I came up with a different solution. As well as yours worked, it did not work for what I need to show. What I ended up doing is adding two calculated columns to my Audit Table.
CountO = If(Audits[Shift]="O",1,0) CountB = If(Audits[Shift]="B",1,0)and added them to my visual. I got the chart and the matrix to display with zeros as I wanted and no unwanted dates.
Thank you for putting up with me. 🙂
Community ChampionAnonymous
Are you using a Date Table covering the range of dates in your model and with continuous dates?
yes, I have a date table:
Calendar = CALENDARAUTO()- PaulDBrown
2 here is what I get using the date table for the x-axis and setting the X axis to categorical
The top chart shows a simple SUM; the bottom shows SUM + 0
PaulDBrown : Unfortunately, that is not what I get. I am counting records, not summing them, as the data table shows the date of the audit, the area audited, the employee audited and the shift as well as an audit ID field. I am counting the Audit ID field as that is what I showed in my original post. Any other thoughts?