Using Slicers to set thresholds

[angusmglfraser]

I want to be able to use a slicer with a numerical field to be used as a threshold when filtering other vizualisations, only taking values greater than, or less than the value in the slicer. Is this possible?

[v-caliao-msft · Accepted solution]

Hi @angusmglfraser,

Based on my research, this requirement cannot be achieved by using aslicer. You need to use a parameter to do it.

Query Editer>Manage Parameter

Reference

https://powerbi.microsoft.com/en-us/blog/deep-dive-into-query-parameters-and-power-bi-templates/

Regards,

Charlie Liao

[v-caliao-msft · Accepted solution]

Hi @angusmglfraser,

Based on my research, this requirement cannot be achieved by using aslicer. You need to use a parameter to do it.

Query Editer>Manage Parameter

Reference

https://powerbi.microsoft.com/en-us/blog/deep-dive-into-query-parameters-and-power-bi-templates/

Regards,

Charlie Liao

[angusmglfraser]

Can this parameter be set by some sort of interactive visual control on a page, or does it have to be done from the "Edit queries" menu? 

[v-caliao-msft · Accepted solution]

Hi @angusmglfraser,

Currently, it have to be done from the "Edit queries" menu.

Regards,

Charlie Liao

[tringuyenminh92]

Hi @angusmglfraser,

 Yes, you can. For normal case (when user selects single filter options), i assume that you have fact table with 3 columns - 1 value column and 2 dims (MeasureA,category1,category2)

• Create new calculated table from value column:

filters = VALUES(Sheet1[MeasureA])

• Create new calculated measure for your fact table

Measure2 = CALCULATE(SUM(Sheet1[MeasureA]),FILTER(Sheet1,Sheet1[MeasureA] >= FIRSTNONBLANK('filters'[MeasureA],1)  ))

but what will be displayed/logic when user selects multiple options? in this case, you could try with max or min method instead of firstnonblank()