Forum Discussion
Power BI Forecast - Using More Data than Visualizing - Hiding Data?
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 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?
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).
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!
