Forum Discussion
relationship
In your visualisation pane you have an area called "Page Level Filters" and "Report Level Filters". That is where you might need to check first. You will need to step through the logic of any filters contained there to see if they might be hiding information long before your slicer has an effect. A filter that affects 1 table, might in turn hide information from other tables its linked to.
Hi Ross,
BRPrint Sum and Latest Report Sum are linked through IDEN on each side. But BRPrint Sum has additional records that do not exist in Latest Report Sum table, if I use Country table to group rows in BRPrint Sum table, it will filter out the additional records in BRPrint Sum. However, I would like to include all records in BRPrint table. that is why I added Country(2), so it does not need to go through Latest Report Sum table.
Does your report have additional page or report filters that might be applied to other areas of your table mapping that could be adversly affecting your output?
Taking the structure of your tables in isolation for the tables mentioned in your OP, nothing immediately stands out with those in particular. Its likely the problem is related to something else that is related but unexpectidly affecting the results.
Yes, I have multiple pages in this report. But a slicer or filter should only affect the visualization on its current page I assume?
In your visualisation pane you have an area called "Page Level Filters" and "Report Level Filters". That is where you might need to check first. You will need to step through the logic of any filters contained there to see if they might be hiding information long before your slicer has an effect. A filter that affects 1 table, might in turn hide information from other tables its linked to.
Thanks Ross!!!!!
I checked query edit, and I am wondering if it has something to do with this. "Limit of 1000 values reached" Do you have any idea how to fix that?