Forum Discussion
Column legend filtering X-axis
Hi guys,
I have a report combining 2 fact tables. One table with actual sales and one with forecast sales. The actual sales table extends to the current month (so March 2023 as I'm writing this), while the forecast extends to the end of the year.
I have created a line and stacked column chart to let me view the actual sales and forecast sales together. I want to see the historical actuals in the bars and the forecast in the line, which works below.
However, when I add a legend in the column legend section, in this case the product category, the future months are filtered out and the forecast line only extends to March (the current month), rather than seeing the future months, even though my date filter is still extended to the end of the year.
Does anyone know why this would happen? I can't think of a reason why the product category would filter the date range.
Any help would be much appreciated.
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.
7 Replies
- lbendlin
Super User
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,
Paddy- lbendlin
agree, 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?