Forum Discussion

JoseCuevas's avatar
JoseCuevas
Regular Visitor
5 years ago

Show/Hide Forecast based on Year slicer

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

. 

bookmark
DAX
Forecasting

1 Reply

  • KBO's avatar
    KBO
    Memorable Member
    5 years ago

    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!