I have 2 multi select parameters - Prop and Page with cascading applied on the page parameter, such that page shows relevant values as per the values selected in the Prop parameter.
The cascading seems to be working fine…When selecting certain prop, then only relevant page is being selected in the page parameter (As seen below)
Moving further to using these parameter in the filters:
The below visual has certain metric aggregated at page level with a custom filter on the page column, only taking values equal to the page parameter.
Irrespective of the page parameter taking only the relevant values(in this case, a total of 5 pages only) the table is showing data for all the pages.
Could someone please help me understand, where am I going wrong???
Thanks in advance!