Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
@jschwab ,
You may take a look at the post below.
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 ?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
77 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |