Forum Discussion
value selection - how this can be done
Hi,
I am creating a report with dynamic query parameters based on a selected values. Let me start from the expected result based on the following screen:
There is a table (1) with a direct query with some parameters due to performance issues. I can change the query parameter value using slicer (2) and this works fine:
My problem is that this is not the format which is recognizable bythe report users. What users know is the format shown on a slicer (4) for which there is a conversion table (3).
My question is if it is possible (and how) to force a selection in a slicer (2) based on a selection from slicer (4)?
I tried to add parameter from slicer 2 into slicer 4 and to create hierarchy, something like that:
but there is an error message that "hierarchy slicers aren't supported for dynamic query parameters"
2 Replies
- amitchandak
Super User
Tomek1982 , for that you can take a measure from the common table and check that is not blank for the second slicer. do not add both to same
- Tomek1982
Helper I
amitchandak the hint you provided is to filter the slicer and this is already working fine. My question was how to set selection in a slicer (2) based on slicer (4) selection