Forum Discussion
Helper ITrend Line Stop at Zero
Is there a way I can extend the trend line to go further but stop at zero?
I'm using the forecasting (gray) and trend (orange) on the line graph, but it stops on the last date I have data in. I would like it to extend to the future to find where the trend line intercepts to zero
Hi jnguyen21 ,
Nope, you can't manually control analyse trend line, it is managed by power bi itself and generated based on data trend.(it not contains options allow you to customize on it)
Using the Analytics pane in Power BI Desktop
But there are other ways to achieve the results you want，by making adjustments to the data.
The following is a sample: sheet 1 is base date，create a new date table have base table [date]+n, create relationship,then create a measure:
Trend Points = IF(HASONEVALUE('Sheet1'[Date]),MAX(Sheet1[Value]), 0)And final you will get the below:
Disadvantage of this method: in a line chart, data with value equal to zero is not accurate, because the original data does not contain zero.
Wish it is helpful for you!
Best Regards
Lucien
2 Replies
- amitchandak
Super User
jnguyen21 , I doubt you can do that
- v-luwang-msft
Community Support
Hi jnguyen21 ,
Nope, you can't manually control analyse trend line, it is managed by power bi itself and generated based on data trend.(it not contains options allow you to customize on it)
Using the Analytics pane in Power BI Desktop
But there are other ways to achieve the results you want，by making adjustments to the data.
The following is a sample: sheet 1 is base date，create a new date table have base table [date]+n, create relationship,then create a measure:
Trend Points = IF(HASONEVALUE('Sheet1'[Date]),MAX(Sheet1[Value]), 0)And final you will get the below:
Disadvantage of this method: in a line chart, data with value equal to zero is not accurate, because the original data does not contain zero.
Wish it is helpful for you!
Best Regards
Lucien
