on 26 Sep 2016 21:17:59
Right now we can only use trend lines for continuous values in the x axis. It would be great if a categorical value could also be used, such as month name.
- Comments (48)
RE: Ability to use Trend Line with Categorical Values in X-axis
2023 and still missing that feature.Anyone has a workaround for a bar chart trend line with categorical values ?
RE: Ability to use Trend Line with Categorical Values in X-axis
Still have this issue and it's 12/19/2022. Sigh.
RE: Ability to use Trend Line with Categorical Values in X-axis
I can't believe this. Today is 2022/7/13. In Power BI, we can only use trend lines for continuous values in the x axis.
RE: Ability to use Trend Line with Categorical Values in X-axis
This is a mandatory component for the line charts. Commonly requested within my organization.
RE: Ability to use Trend Line with Categorical Values in X-axis
This is so frustrating that this is still not an option for categorical data! It makes the chart almost useless without identifying a trend!
RE: Ability to use Trend Line with Categorical Values in X-axis
Seriously cannot believe this doesn't exist.
RE: Ability to use Trend Line with Categorical Values in X-axis
Let's make this happen lovely PBI dev team! This is a valuable attribute. Would be great to make it possible.
RE: Ability to use Trend Line with Categorical Values in X-axis
Would be really valuable to be able to use both the nested x-axis labels and see trend lines at the same time. Especially in the instances mentioned above where users are looking to see trends against a date, and in my case, see that trend over the last few years.
RE: Ability to use Trend Line with Categorical Values in X-axis
This feature is possible within Excel Pivot Tables so would be really nice to find a way to make it work with PowerBI data visuals.
RE: Ability to use Trend Line with Categorical Values in X-axis
I work for the South Australian Health Department and can say with confidence - we really need to be able to have the X-axis dates lined up with the Y axis values, and to be able to choose the date format is paramount. Otherwise our audience is guessing.
Our end users are eager to adapt this product, but get put off when simple changes like having all the dates show WITH a trend line still visible are not available, I would have thought with Charts being the main feature of Power Bi that ALL the different chart options currently available in Excel would also be available in Power Bi.
Please update the Report Server version of Power Bi to have more X-axis date options.