Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Cross report filter

Hi,

I´m creating a number of reports that I want to "tie" together using cross report drillthrough. My reports are all based on the same OLAP cube and are working fine individually. However I have the following issue setting up the drillthrough;

 

I have a visual that contains the measure "Amount". The visual is filtered on the dimension "Managerial hierarchy", using the new filter pane (visual level filter). As a result, the visual now contains an "is not...." filter. This is a standard filter, that I´ve hidden from my end users.

Now I want my end users to be able to filter on the same dimension (Managerial hierarchy). I´ve implemented this by using a page level filter using the new filter pane. This works. 

However when drilling through to my target report, I see strange behaviour. Logically 2 filters are passed through to the target report;

- Managarial level; "Is not...."

- Managerial level; as choosen by user

The result is that only the first filter is taken into account. The "Is not..." filter is overriding the filter choosen by the user. Power BI filters correctly on my initial page, but doesn´t do this on the target page. 

Does anybody know if I´m doing something wrong here? Is this a bug?

I´ve also tried it with a slicer, but the same result.

Any help will be much appreciated!

 

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    After some more checking it seems that the target page doesn´t always refresh. So I see the filter being passed through, but the data are not refreshing. When I hit the refresh button, the data are filtered correctly. I´ve tried multiple browsers and the behaviour is the same. Is this a bug or does this maybe have something to do with our cubes?