Power BI Forecast - Using More Data than Visualizing - Hiding Data?

[wbcogswell26]

Hello! I'm fairly new to Power BI so I hope this isn't an easy question. 

I have a request to create a visual where I layer two line charts ontop of one another; 1 showing 2023 and then forcasting out 2024; the other showing 2024 actuals. However, the ask is to use data back to 2018 to create the forecast. I have created the visual by layering two line charts ontop of one another, one 2018 - 2023 and then adding a forecast; the other just showing actuals. (This also may not be the best solution)

Is there a way to hide years? I need the data to be present for the forecast, but I would like the visual to only be the past completed year and the current year. I know I can actually create a forcast model outside of PowerBI, but figured if the feature is built in it would be an easy viz. I also tried to move the visual into negaitve space; aka chaging the position to -1000 x 10 so that the top 2 year were the only ones on the viz, but it does not seem Power BI has this feature (something I used to do in Tableau). 

Any help would be appreciated! I'm prepping for the answer to be creating the forecast prior to creating the viz, but hoping there is a solution! 

[Greg_Deckler]

@wbcogswell26 One possible solution would be to use the horizontal zoom slider. I will see if I can think of something else. Any chance you could provide sample data or a sample PBIX?

[Greg_Deckler · Accepted solution]

@wbcogswell26 Here's another idea. A third layered visual where you create a measure that returns a value if the date is less than 1/1/2023 but BLANK otherwise. Set width of the line to 1 more than the width of the current line. Set the color to the background color (white).

[wbcogswell26]

The Zoom Slider is a great quick solution, this will at least let me build the inital view, but I imagine I'll have to adjust this monthly as the data changes? It would be amazing if I could set a date as the start of the zoom slider; 

I attempted to load a PBIX having recreated the views using the Super Store Sales data, but I don't have permissions yet to load PBIX files, but essentially its just Month, Year, and Sales. 

I'll try the this view with the white, that may fix the need to adjust the Zoom on a monthly basis! 

Appreciate the help @Greg_Deckler!