Get All Months Even No Data

Question

Hi,i am trying to display a chart for last 12 months, if i use year/month on x-axis but months having no data are not shown on chart.Please help to display all months on chart.Thanks

greg_deckler · Answer

Which chart are we discussion here?

greg_deckler · Answer

Sometimes this works:
&nbsp;
Measure =&nbsp;
&nbsp; VAR __Calc = &lt;some calculation&gt;
RETURN
&nbsp; IF(ISBLANK(__Calc),0,__Calc_)

Forum Discussion

Related content

Month to Month Flow Calculation

Refresh data Once in a Month.

Last 12 months data from current month

FY data for each month

Compare Month to Month Data