topic Show/Hide Forecast based on Year slicer in Report Server

Show/Hide Forecast based on Year slicer

JoseCuevas — Thu, 08 Oct 2020 19:08:57 GMT

I have a radio button slicer that has three (3) Years in it, the current year and two prior years. When a user selects the radio button for the current year, I want the uset to see the line graph with the forecast. When the user selects a prior year I want the user to see no forecast b/c the prior years don't need a forecast. Is there a way to turn the forcast off? I have tried to use bookmarks and put one line visual on top of the other then use DAX or button over the Year slicer, but the slicer requires a simple click, but the button requires a CTRL+click

Re: Show/Hide Forecast based on Year slicer

KBO — Fri, 09 Oct 2020 13:20:12 GMT

Hi JoseCuevas ,

but if you publish the report to the Service/Server. You don't need to push CTRL...it's only requires a "click" ;).

Best,

Kathrin

If this post has helped you, please give it a thumbs up!
Did I answer your question? Mark my post as a solution!