Duplicated Filters with different values in Drill Through

[BishoyGhaly]

Hellow.

Basically i m trying to use the drill through option to detail some sort of data.

I have created two pages, created the required visuals and synced the slicers between them (Slicer selection from 1st page will be applied on detailed page)

To further discuss the issue i need to give more details about the report i m working in.

I have more than one project that i need to visualise its data. When using the drill through option, it only works with the project selected when linking parent and child report through the drill through option, however, when trying to select any other project from the slicer in the parent page, the child visualizations yields a blank visuals.

I checked the Page filters and there is nothing there, also the drill through filters shows the right selection, only when i checked the visual filters (those which are un-editable) i found the filters to be duplicated - almost all of them - with the "Short Name" filters one is showing the current selection which is coming from the synced slicers, and the other filters to the project which was there when linking the parent to child using the drill through option.

Any help?

Case 1 - Default project is selected - Duplicated filters are shown in drop down menu while other drill down filters and page filters are OK

Case 2 - Any other project is selected, no data shown, duplicated filters for the "Short Name" filed have different records with page filters and drill down filters OK

[BishoyGhaly · Accepted solution]

Now it's solved.

The problem was with the slicers syncing.

I had 3 slicers and only 2 of them were set to sync accross the related pages. I fixed the 3rd one and it worked.