Forum Discussion
Column legend filtering X-axis
While I agree that this can be considered a bug there is a workaround. See if you can spot it.
see attached.
I'm unable to upload pbix files unfortunately but hopefully the above link to the OneDrive file will work for you?
I'm starting to think this is just a strange feature of the Power BI visualization rather than any modelling issue, because underneath the cluster column/line chart visual which doesn't show the future months, I have put a Matrix with exactly the same fields and slicers, and the future months forecast is shown. This seems to show it's just a strange quirk of the visual, but hopefully I'm wrong!
Many thanks,
Paddy
While I agree that this can be considered a bug there is a workaround. See if you can spot it.
see attached.
lbendlin How interesting, I did try the 'show items with no data' option but it didn't work with the automatic date hierarchy.
Below, with a date slicer on 2023 dates and using the 'show items with no data' option, all dates in the calendar are shown going up to 2026 despite the slicer.But, as you have done with your file, this option does work when you use the date hierarchy I created myself as shown below.
I can't say I quite understand why this would be the case, but I'm glad to have the solution!
Thanks so much for the help on this, stopped me from tearing my hair out.
Cheers,
PaddyIn most cases you want to avoid the auto date/time feature. It can have massive side effects.