SHOW NO LINE in chart, when NOT reaching ZERO on selected date

[shishir999]

Hi,

I have prepared a Forecasting Line chart, where my forecasting Line is reaching to ZERO within next 6 months. Now, in case, I Select a Date lesser then 6 months (31st Mar), then the Forecasting is not Reaching to ZERO. How can I HIDE the line, if it is not reaching to ZERO on the Selected Date. 

Please help in it.

Shishir

[shishir999]

Could someone help in resolving this issue...Shishir

[v-ljerr-msft]

Hi @shishir999,

As we don't have any options to access the forecast value with DAX formula or other ways, I don't think there is a way to hide the forecast line according to its value currently.

In addition, here is an idea about accessing forecast values in DAX formula. You can vote it up and add your comments there to improve Power BI on this feature. 

Regards

[shishir999]

Thanks v-ljerr-msft for your response.

The said trendline, is based on regression (T= a + bx) formula, but not the pre-defined functionality of PBI. 

I will update to Vote on this.

[shishir999]

Could someone help in it...Shishir

[shishir999]

Could someone help in resolving this issue...Shishir