Forum Discussion
Conditional page level filters
Hi all,
I have an issue where I think dynamic page level fileters could help, but I can't get it working.
In my report, I have some slicers in which users can select region and school division and see the data at their level. Until recently, they had to select one region and below that one, more or all divisions. This selection works through in all following report pages (30 +). No problems here. Recently there was a request if this could be modified to also show national data. I have facilitated this by adding the option in the slicer to also select all regions. If you select all regions of the Philippines, you select the whole nation. So far, so good.
I just now realized that there is a small issue here. The data we present at a national level are at some pages different from the data we present at regional and lower level The difference is based on the following:
For every school in the country we know if they participate in the survey or not. For data at the national level, we display the participation rate once and after that only work with the participating schools. For the regional and lower level, we also show the non participating schools.
In order to get this into PowerBI, I was thinking on adding a conditional powerBI page filter on those pages where the calculation is different. I have variable and a measure that indicate if we are working with national or regional data. I was looking at some kind of a page level filter like this:
If National data” then “exclude non partipating schools” else “use all data” but this seems not to be possible at the page level filters. Do you have a suggestion?