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.

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi,

I have been tried even with the sample table which did you to use to calculate the measure but it shows only 0.

I am uploading the screenshot for your reference. Also, can we use a measue as a slicer or at page level filter?

 

 

Thanks

v-eachen-msft's avatar
v-eachen-msft
Community Support
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.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Yes, it is working for me now.

     Thank you for the soultion.