Forum Discussion
Dynamic Slicer/Filter
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.
In your scenario, "to see over a range the records, but also limit the records based on another value", you need to put the "other field" into a slicer so that data your visual will be sliced based on the selection of that value. And when using Power BI Mobile app, the visual level filter is still available if accessing the report. You can the put the date feild in a slicer since your users need to filter the data within the main report.
Regards,
Simon Hou
