Home

Data Model Dates Do Not Appear To Allow PivotChart Axis Bounds and Units

%3CLINGO-SUB%20id%3D%22lingo-sub-328570%22%20slang%3D%22en-US%22%3EData%20Model%20Dates%20Do%20Not%20Appear%20To%20Allow%20PivotChart%20Axis%20Bounds%20and%20Units%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-328570%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EI'm%20trying%20to%20add%20bounds%20and%20units%20to%20the%20category%20axis%20of%20a%20pivotchart%20populated%20with%20a%20series%20of%20dates.%20The%20Format%20Axis%20dialogue%20recognizes%26nbsp%3Bthat%20the%20Axis%20Type%20is%20a%20date%20but%20no%20Bounds%20or%20Units%20boxes%20are%20shown.%20This%20only%20seems%20to%20occur%20if%20the%20dates%20are%20from%20a%20power%20query%20populated%20datamodel%2C%20a%20series%20of%20dates%20from%20a%20range%20of%20workbook%20cells%20works%20fine.%20There%20are%20no%20gaps%20or%20null%20values%20in%20the%20datamodel%20data.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EAny%20pointers%20would%20be%20much%20appreciated.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EThanks%2C%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3ELou%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-328570%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

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