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

[jschwab]

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 another post with the explanation that Trend Lines only work on numerical values (ie fails when expanding to Months, which is Text). But if that is the case, why do Trend Lines continue to work on Line Charts and Area Charts when expanding down to the Month level ?

Just as a note, this issue occurs on the Line and Clustered Column Chart as well.

[v-chuncz-msft]

@jschwab ,

You may take a look at the post below.

https://community.powerbi.com/t5/Desktop/How-to-draw-find-a-Trendline-in-PowerBI-August-2017-Preview...

[jschwab]

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 ?