Hi,
Apologies if this is the incorrect forum. 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 recognises 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 workbook works fine. There are no gaps or null values in the datamodel data.
Any pointers would be much appreciated.
Thanks,
Lou
Apologies if this is the incorrect forum. 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 recognises 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 workbook works fine. There are no gaps or null values in the datamodel data.
Any pointers would be much appreciated.
Thanks,
Lou