Forum Discussion
Advocate IHidden page filter?
Hi all
I need some help
I loaded from a database the table ACADEMIC_YEAR, with one columne AY, and three rows, with values 2017, 2016 and 2015.
I defined two calculated column:
* AY_ORD = MAX(ACADEMIC_YEAR[AY]) - ACADEMIC_YEAR[AY]
* A.Y. = [AY] & "/" & RIGHT(([AY] + 1);2)
AY is the first part of the academic year
AY_ORD is the position of the academic year in descendimg order
A.Y. is the complete string for the acaemic year
AY A.Y. AY_ORD
2017 2017/18 0
2016 2016/17 1
2015 2015/16 2
I defined three identical sets of visuals, each one with filter AY_ORD = n, with n respectively 0, 1 and 2, in order to compare a distribution of some data in the three years.
It works fine, until I refresh the data with a new set of values: 2018, 2017 and 2016.
If I clone the visuals into another page, I obtain the correct result.
It looks like the original page has a filter ecluding the AY 2018, but I can't find it.
What can i look for?
Thanks.
Luigi
Thank you for the reply.
I've already checked report lever filters.
This mornig I found the catch (after a good sleep).
Using the selection pane I found hidden slicers, coming from syncronization with slicers defined on other pages in early implementation, and then deleted.
So the caveat is: before deleting a slicer, check for sync you mau have forgotten.
Bye
2 Replies
v-cherch-msftMicrosoft Employee
Hi 10246532
You may check the Page lever filters or Report lever filters when you don't select any visual.
Regards,
Cheire
10246532Thank you for the reply.
I've already checked report lever filters.
This mornig I found the catch (after a good sleep).
Using the selection pane I found hidden slicers, coming from syncronization with slicers defined on other pages in early implementation, and then deleted.
So the caveat is: before deleting a slicer, check for sync you mau have forgotten.
Bye