Jan 31 2019 05:54 AM
I'm trying to add bounds and units to the category axis of a pivotchart populated with a series of dates. The Format Axis dialogue recognizes that the Axis Type is a date but no Bounds or Units boxes are shown. This only seems to occur if the dates are from a power query populated datamodel, a series of dates from a range of workbook cells works fine. There are no gaps or null values in the datamodel data.
Any pointers would be much appreciated.
Thanks,
Lou