Forum Discussion
Dynamic Slicer/Filter
I was able to get the filtering to work with the selection on the right hand side, but my client just wants to use the main report if possible. The other issue is that they are using the mobile app (android and iOS) and the filtering isn't available on the side, while the slicers (or another approach, if there is one) would be available.
You can't place a measure on a slicer. You could potentially create a disconnected table of values and use that as a slicer. Then write you measure to respect this table. Eg if your measure returned a number 1 through 100, then you could load a table with values
25
50
75
100
Then write a measure something like
Result = calculate([my original measure],filter(data,[my original measure] <= max(table[myValue]))
The exact formula will depend on your data model, but the principle is the same. The disconnected table exists solely to receive input from the user. the MAX(table[myValue]) will harvest the user selection and allow it to then filter the rest of your data model.