Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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)
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.
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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |