Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Dynamic Slicer value

Hi, I have 2 different fields(Region and Status) which I want to use as a slicer in my report. Status slicer values should be based/changed on the selected value in Region Slicer. Please refer the b...
Need Help
  • v-eachen-msft's avatar
    v-eachen-msft
    6 years ago

    Hi Anonymous ,

     

    Column cannot display a dynamic result, you need to use measure. According to my test file, you need to use measure as a rule in the filter pane of the second slicer.

    Presumably you have already tried, measure can't be used as a slicer or at page level filter.

     

v-eachen-msft's avatar
v-eachen-msft
Community Support
6 years ago

Hi Anonymous m

 

You could create a measure and put it into filter pane to show the result.

Measure =
SWITCH (
    TRUE (),
    SELECTEDVALUE ( 'Region'[Region] ) = "Italy"
        && SELECTEDVALUE ( 'Status'[Status] ) = "Open", 1,
    SELECTEDVALUE ( 'Region'[Region] ) = "Germany"
        && SELECTEDVALUE ( 'Status'[Status] ) = "Closed", 1,
    SELECTEDVALUE ( 'Region'[Region] ) = "France"
        && SELECTEDVALUE ( 'Status'[Status] ) IN { "Waiting", "Closed" }, 1,
    SELECTEDVALUE ( 'Region'[Region] ) = "Spain"
        && SELECTEDVALUE ( 'Status'[Status] ) = "Others", 1,
    0
)

Here is my test result and test file for your reference.