Display Dates on Axis Where They Don't Exist

[knotty150]

Hi All

I have a dataset which is something like this:

Date | Amount
01/01/2015 | 10
01/03/2015 | 9
01/04/2015 | 6
01/05/2015 | 11
01/07/2015 | 15

As you can see, there are no entries for Feb (02) or June (06). I'd like to display both Feb and June as 0 values on a PivotChart (line chart to be precise), but Excel just plots the graph and goes straight from Jan to March, without displaying anything for Feb. I'm linking the dataset over to a standard "Master Dates" table on date but that still doesn't have any effect.

Is there something I can do to include these null months?

Thanks

Rich

 

[ranman256]

you must insert the months there, with no data.

 

[scottsen]

For Pivot Tables, there is an option to show rows with no values -- but I'm actually not super sure that exists for Pivot Charts. It... probably does?

Your other option is to tweak your measure. Say, if you have:
Total := SUM(MyTable[MyField])
You can add...
Total - No Blanks := IF ([Total] = BLANK(), 0, [Total])
assuming you are okay reporting the values as "zeros"