Thank You for posting your query onto the Forum.
The example that you’ve portrayed as mentioned in the above post - "*I need to develop a conditional filter that is able to select multiple customers, with a maximum of 1 product per customer.
I.e., say I have 3 customers and 10 products per customer. This means I can only ever select 1 product at a time per customer."
You can simply do this by applying settings under the “Formatting” of the individual slicers. That is, you want to select multiple Customer Names but only one Product Name at a given time. So select the “Customer Slicer” and under the formatting tab go to the selection controls option and then disable the “Multi-select with CTRL” option below is the screenshot provided for the reference -
It’ll be “Enabled” by default, just click on it to disable that option.
Now, once you do this for “Customer Slicer” you’ll be able to select multiple Customers at a given time but only single Product will be selected from the “Products Slicer” because this option is not exercised for the Products slicer. Below is the screenshot provided for the reference where multiple Customers are selected but only single Product is selected for all those selected Customer Names-
Also would it be possible, say if I select a product for a customer, and then now go and select another product for the same customer, can the previous selection be automatically removed, and only accept the most recent selection? - Yes this is absolutely possible. Refer the screenshot provided below where when I select the new Product name and the previously selected Product name will automatically gets discarded -
I’m also attaching the PBIX file of the working for the reference.
Hoping you find this useful and meets your requirements that you’re looking for.
Thanks and Warm Regards,
Custom Conditional Formatting.pbix (662.3 KB)