Forum Discussion

jschwab's avatar
jschwab
Frequent Visitor
7 years ago

Trend Line Disappears When Expanding Down the Hierarchy on Clustered Column Chart

When setting a date with a hierarchy on the X-Axis to a Clustered Column Chart, I can add a Trend Line at the Year level. But when I expand the hierarchy down to Months, it disappears.   I saw anot...
Need Help
jschwab's avatar
jschwab
Frequent Visitor
7 years ago

Thanks for your response v-chuncz-msft  !

That post advises that only Continuous Charts can have a trendline.

My Clustered Column has a Continuous X-Axis at the Year Level:

But Categorical at the Month Hierarchy, so the Trendline disappears:

Or rather I should say the "Type" section disappears entirely, I'm assuming it switched back to Category because of the way the X-Axis looks.

Is this a bug ?