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 ,

 

The formula seems to be right. Are the "Region" and "Open Needs Status" are all single values? You could upload your files without any Confidential Information to OneDrive for Business and share the link here.

 

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.