Power Bi

[Himaja95]

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

[kpost · Accepted 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

sloped line = -916.67*distinct(Date_Table[Year]) + 1870000

You can then format the line's style to make it a dashed line .

line.

[Himaja95]

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

[mario_ruiz]

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.