Slicer which affects table based on value of another slicer

[JemmaD]

Hi,

So hopefully I can explain this properly.

I have a table showing month & year, and sales amount. My clients want a (>=) slider with the sales amount from 0 to max amount so they can filter the table on high or low sales values. I've done this. Bit.

BUT - they also want a filter on top of the slider, with three values 'Attritional' 'Large' and 'Total' - when the user selects 'Attritional' it will filter the table on anything lower than the selected slider value. When the user selects 'Large' it will filter the table on anything higher than the selected slider value. 'Total' ignores the slider I guess (greater than, less than and equal to the value in the slider).

I have created a table which simply holds large, attritional and total but I have NO idea how get this to apply to my sales value. 

[Greg_Deckler · Accepted solution]

@JemmaD You need a Complex Selector. https://community.powerbi.com/t5/Quick-Measures-Gallery/The-Complex-Selector/m-p/1116633#M534