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.
Trying to design some "buttons" by augmenting slicers. Please see below. Is there any way I can limit values in a slicer? For instance, I just want there to be the current week, last week, etc ... not the deselect or the blank option.
Solved! Go to Solution.
There is a bug that disables visual-level filters for slicers. You can workaround it by changing the slicer to another visualization (card or table or whatever), then selecting your visual-level filter (in your case, value is not blank), then changing the visualization back to a slicer. The filter won't actually show up in the slicer's visual-level filter menu, but it will still be applied.
How are you creating the values. e.g. last 7 days, WTD, for the slicer? I'd like to do something similar with Google Analytics data. Feel free to msg me directly so this thread doesn't go off track.
Thanks,
Jeff
There is a bug that disables visual-level filters for slicers. You can workaround it by changing the slicer to another visualization (card or table or whatever), then selecting your visual-level filter (in your case, value is not blank), then changing the visualization back to a slicer. The filter won't actually show up in the slicer's visual-level filter menu, but it will still be applied.
This solution isn't working for me in Version: 2.38.4491.282 64-bit (August 2016)
Yes, this workaround was disabled a few months ago. Please vote on the following idea to bring it back:
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 |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |