Forum Discussion

naizam's avatar
naizam
Icon for Helper II rankHelper II
6 years ago

Change Forecasting period using a slicer

Hello experts,   I have a line chart with forecast period set to one year using the analytics pane. Is there a way to use a slicer to change the forecast period? So users can dynamically change the...
Need Help
Tips and Tricks
v-xuding-msft's avatar
v-xuding-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi naizam ,

For using analytics pane, do you mean use Use insights in Power BI Desktop to explain increases and decreases seen in visuals ?

If so, it is impossible to filter the period unfortunately. We only can create a calculated column to calculate the forecast values and then use it as a slicer to filter.

 

If I misunderstand, can you please share more details and some screenshots?

 

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Kudos are nice too.

  • naizam's avatar
    naizam
    Icon for Helper II rankHelper II
    6 years ago

    Thank you for looking into this. By analytics pane, i meant using what is shown in the below screenshot

     

    • v-xuding-msft's avatar
      v-xuding-msft
      Icon for Community Support rankCommunity Support
      6 years ago

      Hi naizam ,

      Apologize for misunderstanding. Currently, it's not available to use a slicer to change the forecasting period.  If we want to filter the period, we need to calculate the forecasting values.  You could reference the blog which teaches us how to calculate forecasting values.

      http://blog.gbrueckl.at/2015/04/recursive-calculations-powerpivot-dax/

       

      Best Regards,

      Xue Ding

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Kudos are nice too.