Forum Discussion
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...
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.
Hi Anonymous
show, please, all your data model
it seems like you need some bridge table like
| Region | Status |
| Italy | Open |
| Germany | Closed |
| France | Closed |
| France | Waiting |
| Spain | Others |
you need also dimesion tables with unique region and unique status related to this bridge
and fact table related to dimensions