I have two columns. One is DAY_NUM and other is Sales(Cumulative) measure.
Day_num has Days till 23 like D1,D2,D3......D23. But my cumulative sales are present till Day 21.
I need to show sales till Day 1 to Day 21 in addition with Day 22 and Day 23 sales as zero/null in a BAR CHART.
When I try to drag Day_num and sales, till Day 21 im getting exact values but for Day 22 and Day 23, my Day 21 values are getting displayed. Don't know the Issue.