topic Re: Adding trendline for categorical x-axis in DAX Commands and Tips

Adding trendline for categorical x-axis

Anonymous — Thu, 28 Apr 2022 13:49:31 GMT

Hi,

I want to add trendline to my graphs where x-axis is categorical. I am looking for some workaround as trenline option comes only for continous values.

I tried creating a DAX measure with liner regression but as my x axis is not numerical that didn't worked for me.

Attaching screenshot how i want to create a graph.

Re: Adding trendline for categorical x-axis

v-chenwuz-msft — Mon, 02 May 2022 07:35:01 GMT

Hi Anonymous ,

You can try Analytics pane in Power BI Desktop.

Use the Analytics pane in Power BI Desktop - Power BI | Microsoft Docs

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Adding trendline for categorical x-axis

Anonymous — Mon, 02 May 2022 09:33:34 GMT

This option will not come, if the axis values are categorical.