Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello everyone,
I'm struggling with a chart that always semmed simple in excel, but I'm not able to achieve in Power Bi Desktop.
I've sales data (data, amount). I've created a calculated column with the month of the date. Then I plotted amount per month. This gives me a 12 column chart, where each column represents a month, and the value is the sum of amount.
Now, I want this chart to have a "linear" trendline. How do I calculate this values ? I've seen some posts on how to calculate the formula y = ax +b, but it ended up being impossible to me.
Appreciate the help,
Regards,
GV
Solved! Go to Solution.
Check out my DAX Simple Linear Regression Pattern here:
Check out my DAX Simple Linear Regression Pattern here:
Hi smoupre
Ii worked. Thank you !
User | Count |
---|---|
77 | |
74 | |
63 | |
61 | |
45 |
User | Count |
---|---|
108 | |
102 | |
93 | |
83 | |
64 |