Forum Discussion

hemingt's avatar
hemingt
Icon for Helper V rankHelper V
7 years ago
Solved

Is it possible to valid the Slicer input

  Hello , is it possible to allow the only valid input data? for example, in the snapshot, only the data between 1903~1935 was allowed to input, other data was not accepted. Thank you!
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi hemingt ,

     

    I already tried this.
    As per my previous reply, If user input any dates out of range values. Power BI slicer will not be able to detect this.
    But, once the user click on left or right slider , it will give min and max values available in slicer as per date variable.

     

    Regards,
    Amit

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi hemingt ,

 

I am not getting the meaning of legal data.

What I have tried, If you input ilegal data say 1111

If you click on left slider, automatically it will pick the min date for that date variable.
Same behaviour with max date for date variable.

I am sure, there is no logic for validate legal data.

 

Dont forget to give Kudos when an answer is helpful or the solution


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Thanks,
Amit

hemingt's avatar
hemingt
Icon for Helper V rankHelper V
7 years ago

Hi Anonymous 

for your example, you range is ~2014, 

What I expect is do not let user to input such as 2015,2016.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi hemingt ,

     

    I already tried this.
    As per my previous reply, If user input any dates out of range values. Power BI slicer will not be able to detect this.
    But, once the user click on left or right slider , it will give min and max values available in slicer as per date variable.

     

    Regards,
    Amit

    • hemingt's avatar
      hemingt
      Icon for Helper V rankHelper V
      7 years ago

      thank you Anonymous