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.
I have a fact table with sales data which includes a SalesPeriod value. A related SalesPeriod table contains the SalesPeriodID that ties back to the Sales table and includes a "DateOfSales" column which is a datetime. When I add a column visualization, I would like to be able to add a trend line, but do not see that option under the Formatting tab.
Note, there is one row in the SalesPeriod table per month where the DateOfSales values are the 1st of each month (all sales occur in a given month.year, aggregated in the data I am provided). I have select Continuous for the X-Axis type (which is the date field) and get expected results, but do not see a Trend Line option using the latest PowerBI desktop update.
I'm pretty new to this, so must be missing something obvious, but cannot figure this one out!
Solved! Go to Solution.
@avisingh hey there stranger.. so I have been searching EVERYWHERE on how to do a Trend lines in PBI... I know this video is old, they must have removed this feature because everyone shows the same thing you do all over the web (old nothing updated) but this option in no longer under (Visualizations) Analytics for Bar or Line charts... I have been struggling for a week to find help from someone... My management LIVES ON TREND LINES in Excel.. I don't want to go backwards with using Excel its too much work... can you help me? Power On!!
Avi,
Wow, thanks for that very helpful video. EVERYTHING I read on trend lines indicated that it was under the Formatting tab, not Analytics. Watching your video pointed in to exactly the right place and my visualization is not working. Many thanks for the help, now if only MS could fix the documentation!
This is very cool, but...I have a Line and Clustered Column chart, with two clustered columns and one line. I want individual trendlines for the columns, but no trendline for the line. When I add a new trendline, I get two by default--one that combines the column data, another for the line. When I turn off "Combine Series" the column trendlines separate, but the line trendline remains. Any way to control the trendlines independently?
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 |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |