Create Single Value Slicer

[jeje09]

Hello, hope someone can help me on this report. exhausted all possible scenarios but unable to find one.

I want to create a single filter or slicer for the minimum and maximum value (for the users to have the ability to put a SINGLE value only).

for example, I have a filter selected (prob1). as per the selected filter, it should get both the minimum and maximum value that can be seen on the "probability_val" column, so the single value slicer should fall ino these values only (e.g minimum value is -4 while maximum is 349,900) so it is imperative that in the single value slicer, users can only put within this range. so both the minimum and maximum value is dynamic depending on the filter selected (probability column).

The reason behind this are as follows:
       1. Dynamic Filtering Based on User Input

• Users can set a custom range by defining a Minimum and Maximum value for the selected metric (prob1, prob2, etc.).
• This allows them to focus on applications that fall within a specific threshold.

  2. Default Values Based on Actual Data

  • The slicers should default to the actual minimum and maximum values of the selected metric (prob1, prob2, prob3 or prob4)
  • This ensures that when a user first interacts with the report, they see the full range of data.

    3. Interactive Data Exploration

    • Users can adjust the range dynamically, filtering out values that are too high or too low for their analysis.
    • For example, if a user sets:
      • Min Value = 10
      • Max Value = 50
      • The dataset will only show records where the metric (probability_val) falls within 10 to 50.

this is the sample data

store_id	certifying_body	probability	probability_val
sid-10050	safe_deck	prob1	-4
sid-10051	crocs_bless	prob2	-2
sid-10052	safe_deck	prob3	-1
sid-10053	crocs_bless	prob4	0
sid-10054	safe_deck	prob1	-4
sid-10055	crocs_bless	prob2	-2
sid-10056	safe_deck	prob3	-1
sid-10057	crocs_bless	prob4	0
sid-10058	safe_deck	prob1	40
sid-10059	crocs_bless	prob2	10
sid-10060	safe_deck	prob3	340
sid-10061	crocs_bless	prob4	850
sid-10062	safe_deck	prob1	50
sid-10063	crocs_bless	prob2	25
sid-10064	safe_deck	prob3	48
sid-10065	crocs_bless	prob4	38
sid-10066	safe_deck	prob1	69
sid-10067	crocs_bless	prob2	74900
sid-10068	safe_deck	prob3	84000
sid-10069	crocs_bless	prob4	106100
sid-10070	safe_deck	prob1	349900
sid-10071	crocs_bless	prob2	43700
sid-10072	safe_deck	prob3	47900
sid-10073	crocs_bless	prob4	950
sid-10074	safe_deck	prob1	500
sid-10075	crocs_bless	prob2	20700
sid-10076	safe_deck	prob3	28800
sid-10077	crocs_bless	prob4	-4
sid-10078	safe_deck	prob1	-1
sid-10079	crocs_bless	prob2	0
sid-10080	safe_deck	prob3	0
sid-10081	crocs_bless	prob4	-2
sid-10082	safe_deck	prob1	0
sid-10083	crocs_bless	prob2	220
sid-10084	safe_deck	prob3	230
sid-10085	crocs_bless	prob4	560
sid-10086	safe_deck	prob1	780
sid-10087	crocs_bless	prob2	678
sid-10088	safe_deck	prob3	450
sid-10089	crocs_bless	prob4	4890
sid-10090	safe_deck	prob1	563
sid-10091	crocs_bless	prob2	200
sid-10092	safe_deck	prob3	400
sid-10093	crocs_bless	prob4	550
sid-10094	safe_deck	prob1	5666
sid-10095	crocs_bless	prob2	4560
sid-10096	safe_deck	prob3	7890
sid-10097	crocs_bless	prob4	7673
sid-10098	safe_deck	prob1	341
sid-10050	crocs_bless	prob2	51
sid-10051	safe_deck	prob3	23
sid-10052	crocs_bless	prob4	24
sid-10053	safe_deck	prob1	26
sid-10054	crocs_bless	prob2	79
sid-10070	safe_deck	prob3	500
sid-10071	crocs_bless	prob4	43700
sid-10072	safe_deck	prob1	47900
sid-10073	crocs_bless	prob2	950
sid-10074	safe_deck	prob3	4560
sid-10056	crocs_bless	prob4	7890
sid-10057	safe_deck	prob1	7673
sid-10058	crocs_bless	prob2	341
sid-10059	safe_deck	prob3	43700
sid-10060	crocs_bless	prob4	47900
sid-10061	safe_deck	prob1	950
sid-10062	crocs_bless	prob2	500

[Sahir_Maharaj]

Hello @jeje09,

Can you please try this approach:

Min_Probability_Val = 
CALCULATE(
    MIN('Table'[probability_val]),
    ALLSELECTED('Table')
)

Max_Probability_Val = 
CALCULATE(
    MAX('Table'[probability_val]),
    ALLSELECTED('Table')
)

[jeje09]

Hi @Sahir_Maharaj , yes it will get the minimum and maximum value. however, i would need the SINGLE value slicer input.

• For example, if a user sets:
  • Min Value = 10
  • Max Value = 50
  • The dataset will only show records where the metric (probability_val) falls within 10 to 50.

[Irwan · Accepted solution]

hello @jeje09 

i might be misunderstood, but i think you can do this by using "between" slicer if you only want to show all value in between.

your users can set the number they want at those minimum and maximum boxes in slicer visual.

combining with @Sahir_Maharaj 's DAX, you can show min or max value of the selection for interactive visual.

Hope this will help.

Thank you.