Skip to main content
cancel
Showing results for 
Search instead 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

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

 

Please Help

 

CHART 1

Himaja95_0-1690383834818.png    

CHART 2

Himaja95_1-1690383938155.png

 

 

1 ACCEPTED SOLUTION
kpost
Super User
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 .

help.pngline.

View solution in original post

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

help.pngline.
Himaja95
Helper I
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

Himaja95_0-1690388721835.png

 

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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors