Hello,
I have a report that has DirectQuery and Import data. The database is very large. For security reasons, I'll use a sales example in this question.
To reduce query times, in the first page of the report, I have added a slicer that subselects the data. Here, the slicer allows the user to select the customer and year. This selection is applied to every visual in the second page using the synch slicers functionality. I also have a slicer on the second page that allows the user to select a type of product. When I click on any visual, it tells me that the filters of selected customer and year as well as type of product has been applied. All visuals look as expected.
I have a line plot and a corresponding matrix visual in the second page, both plotted against timestamps. They are both filtered correctly by the custome, year and type of product. When I highlight some data in the line plot, however, the query sent back does not apply the customer, year and type of product filters. It instead, just selects the timestamps (the x-axis) and looks at the entire (very large) fact table. This massively slows down the query which often times out. If instead I select rows from the matrix, the corresponding query filters according to the customer, year and type of product as well as the timestamps and shows the data in the line plot relatively quickly.
I don't understand why highlighting the line plot data overrides visual filters that are already applied by the slicers in page 1 and 2. Is there a way to fix this?
Thank you!
