Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
76 | |
64 | |
63 |
User | Count |
---|---|
142 | |
105 | |
102 | |
80 | |
67 |