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 ,

 

This slicer is using the data from the dataset. Whatever the dataset value you have , it will show the ranges of dates either in List, Dropdown, Between, Less than or equal to and Greater tahn equal to.

 

For the particular date variable, whatever catergorical variable you will add, it will show list of dates from min to max present in the dataset.


Its a visual , used to slice and dice the data , hence not possible to allow valid input data. you can do search also, but it will filter only the data that catergorical variable has.
Here data is nothing but what the varibale having data for a particular dimension what you keep in Field section.

 

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

 

Thanks,
Amit