cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper I

## Power 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.

CHART 1

CHART 2

1 ACCEPTED SOLUTION
Super User

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.
3 REPLIES 3
Super User

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.
Helper I

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

Helper 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.