Forum Discussion
Dynamic Slicer/Filter
I am currently developing a page that has the date slicer, but my client would also like to filter on a calculated value (IE another field). This would allow for them to see over a range the records, but also limit the records based on another value. I seem to be able to complete this on a dashboard by asking questions and I can also add a filter on the visual or page, but the filter is not dynamic like a slicer. I see a post and just voited for it (Allow any kind of values in a Slicer like the new date slicer), but am wondering if anyone has a solution in the meantime?
Also note, that my client would like to see everything less than the value selected (0-100)
4 Replies
If you open the filter pane on the right hand side of the visual canvas, you can select a filter like this there.
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.
