Forum Discussion

Tomek1982's avatar
Tomek1982
Icon for Helper I rankHelper I
3 years ago

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"