Forum Discussion
Helper IPower Bi
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
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 2040sloped line = -916.67*distinct(Date_Table[Year]) + 1870000
You can then format the line's style to make it a dashed line .
line.
3 Replies
kpostSolution Sage
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 2040sloped line = -916.67*distinct(Date_Table[Year]) + 1870000
You can then format the line's style to make it a dashed line .
line.
mario_ruizHelper II
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.
Himaja95Data 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