Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi Everyone,
I made a stacked bar graph (CHART1) and intended to show a trend line till 2040, which isn't appearing on this bar graph.So I modified the graph (CHART 2) and enabled the trend line.However, I need to display that line in a slowly decreased manner to 0 till 2040.
Please Help
CHART 1
CHART 2
Solved! Go to Solution.
Make it a "line and stacked column" chart, then create a measure using slope intercept form and the YEAR as the x value... ( y = mx + b ) where :
M is the slope calculated by using the points (2016, 22000) and (2040, 0), or -916.67.
I did the math and got this as your line measure based on an initial value of 22000 in 2016 and going to 0 in 2040
Make it a "line and stacked column" chart, then create a measure using slope intercept form and the YEAR as the x value... ( y = mx + b ) where :
M is the slope calculated by using the points (2016, 22000) and (2040, 0), or -916.67.
I did the math and got this as your line measure based on an initial value of 22000 in 2016 and going to 0 in 2040
Data is only available till 2022.Forecasting option isn't available for the bar charts That I selected. I have to display the trendy line as below chart (used Tableau) in POWERBI
Is the data missing till 2040? Because it's not showing it, it seems You don't have any more data to show. You could try to forecast and see if the AI reconstructs the data till 2040 year.
User | Count |
---|---|
109 | |
101 | |
100 | |
69 | |
34 |
User | Count |
---|---|
146 | |
141 | |
116 | |
98 | |
52 |