cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
hemingt Member
Member

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! 360截图-161728656.jpg

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Is it possible to valid the Slicer input

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

8 REPLIES 8

Re: Is it possible to valid the Slicer input

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

mussaenda Senior Member
Senior Member

Re: Is it possible to valid the Slicer input

I don't know if it's possible but you might want to try this custom slicer

 

Untitled.png

Re: Is it possible to valid the Slicer input

Hi @mussaenda@hemingt ,

 

I think, no need to use custom visual for this. Whatever slicer we have in Power BI desktop. We can use same slicer and change the orientation to horizontal.
2019-04-11 12_27_56-Show data - Power BI Desktop.png

If you use custom visual , it will slow down the page rendering in app.powerbi.com
Even some of the custom visual doesn't support export to PDF or Powerpoint, so for this need, you can simply use slicer present in Power BI desktop.

 

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 Member
Member

Re: Is it possible to valid the Slicer input

Hi @Amit_PowerBIPro @mussaenda 

thank you for your reply.

I really want the Slicer show as between,  the between style has two ways to adjust the range. One way is to adjust the slide, the other way is to input the data directly. My concern is here, when user input the data directly to adjust the range, I want to only allow the legal data can be input.

Hope it's clear now.

Re: Is it possible to valid the Slicer input

Hi @hemingt ,

 

I am not getting the meaning of legal data.

What I have tried, If you input ilegal data say 1111
2019-04-11 13_56_07-Show data - Power BI Desktop.png

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 Member
Member

Re: Is it possible to valid the Slicer input

Hi @Amit_PowerBIPro 

for your example, you range is ~2014, 

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

Re: Is it possible to valid the Slicer input

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 Member
Member

Re: Is it possible to valid the Slicer input

thank you @Amit_PowerBIPro 

Helpful resources

Announcements
Community Highlights

Community Highlights

Find out what's new in the Power BI Community!

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 402 members 4,330 guests
Please welcome our newest community members: