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.
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 !
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 |
---|---|
117 | |
107 | |
69 | |
68 | |
43 |
User | Count |
---|---|
148 | |
103 | |
103 | |
88 | |
66 |