Forum Discussion
Resolver ISelect / deselect (toggle) 1 specific customer on / off in a simple way
We have around 10K customers
one of this 10K we often need to switch off an since it is a hazzle to have a slicer with 10K customrs, and then hit select all, then deselecting this one in the lower 2/3 of the list i want to find a better way
I thought about making a filter and then a bookmark, but then all the filters and sorting the customer have made will be lost each time i hit that button linking to a bookmark.
Idealy i want a button that has "customor YY - ON" and then Button "Customer YY OFF" - not linking to a bookmark since that would also reset other filters.
Hi Rygaard
So you need the default view to be all customers, where you can include/excluse 1 specific customer with a toggle button. I've had this exact problem before, I simply solved it by doing the following:
- Create a new column in your data with the following DAX: NewColumn = IF(CustomerName = "Customer X"; "Customer X"; "All Customers").
Now you can create a slicer with this column. The slicer will have 2 values. The "All Customers" value should be ticked by default, where the "Customer X" should not be ticked by default, therefore not including it in the data. Once it is ticked it will include all customers including Customer X.Let me know if this helps!
The method with the calculated column is generally something you would do in a dimension table. A table containing only the 10000 distinct customers and their customer related data. If you start creating several column in you main sales table you will proberbly get performance issues eventually.
9 Replies
- Rygaard
Anonymous
there is one customer i want to be able to deselect or include.
so either:
view all customers including customer "YYY"
or:
view all customers but not customer "yyy"
since there is a ton of other filters, like segments, regions, dates, teams and so on i want an easy way to toggle this one customer on/off.
(the problem beeing that this customer is so big we often do not include it when we are looking at performance, since smalle departments performance would be drowned out by the volume from this one )
So some people need to look at the numbers without this customer - and yes i could make a slicer where you can then
"select all"
scroll down about 8K customers
"Deselect this one i want do deselect"
but for the avarage user this is a hazzle.
v-piga-msftResident Rockstar
Hi Rygaard ,
Idealy i want a button that has "customor YY - ON" and then Button "Customer YY OFF" - not linking to a bookmark since that would also reset other filters.
For your requirement, I think you need create the bookmark with button to achieve reset the slicers.
Please refer to this blog which should be helpful.
Best Regards,
Cherry
- Rygaard
This has to be a robot postig since im specifik asking for a solution that do not reset filters, and you even quote me for that.
- tex628
Community Champion
If you make a calculated column in your customertable you can give that customer a "1" while giving every other customer a "0". Then use a slicer to remove that specific customer by selecting "0".
