Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
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
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.