I have lots of customers in my data and I want a quick way to omit customers from the report to see how this affects everything. But all the slicers seem to be about selecting a record from a list
Is there anything in Power BI where for example, I can add the Customer ID and it gets removed from the report. I dont want to do it in filters because you need to use advanced filtering and keep adding or. There might end up being hundreds of Customers that get filtered out and this would be to complex for the user
I cant see an option to have everything selected from the start in the slicer. I dont really want the use to have to turn on select everything before they start. Am I missing an option to select everything in the slicer rather than having to switch it on
It seems like this could be an idea for a new slicer visual? For my logic, the business is looking at Outliers. If they have looked into an outlier and are happy that they have come to a conclusion they simply want to omit as they go
I totally agree with you that regarding the requirement for a new slicer. The select all option is located under the selection controls options for the slicer. Once you have enabled it you select all on that specific slicer, save the report and then that should mean that any user that opens the report will have all options selected from the beginning.
The only issue that i can think of is that i dont know how it handles new records. For example when you get new customers, will they also be selected by default?
If you will save the report with "Select All" option and if any new option/item will be added to the list, then it will be selected by default. And in case if you have unchecked certain items from the slicer and then save the report, they will remain unchecked untill the selection has been reversed.
Hope this helps.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I have thousands and thousands of attributes to go through. The user should be able to simply type in the ones they want to omit. Not scroll through because there are too many to scroll through. So this solution doesnt work in this situation. Its only good for a smaller number of records
My only concern now is that the Slicer is in a slicer bookmark.
in the pbix file in Desktop Ive set it to all with everything selected. Added a search at the top and saved. Im concerned that the user will go in. remove the Properties they want removing and go back to the filter and it will reset with the settings from my pbix file.