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.
Please show your data model. Usually these two fact tables should not be connected. Instead, they should be controlled by a common Dates dimension table. The X axis on your visual should be fed from that table too.
Hi lbendlin thanks for getting back to me.
Below is the data model. The two fact tables aren't connected, and they are both connected to the materials (products) table and calendar table as you'd normally expect, so I can't see anything in the data model which would cause this.
Any ideas?
Many thanks,
Paddyagree, that looks benign. And you confirmed the x axis is fed from the Calendar table?
Would you be able to create a sample pbix that illustrates the issue?
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