Forum Discussion
max value selected in date slicer
I need both the features 1. Force Selection 2. Max. limit of selection in one visual. If I select more than 3 it show error message and not allow me to select. Is it possible?(NOt for Date)
Hi Anonymous
You could set a default slicer by "ChicletSlicer" visual,
go to https://app.powerbi.com/visuals/ and download "ChicletSlicer" visual.
Once you download it select visualisation under settings change Forced option to On.
"If they select more than 3 values it should throw some error message",
This can be done by creating measures:
Selected Count = if(ISFILTERED(Sheet3[ItemId]),CALCULATE(SUMX(VALUES(Sheet3[ItemId]),1)),0) Message = if([Selected Count]>3,"Please Select Only 3 Values"," ")
Add "Message" in a card visual, turn "Category' off,
But "the 4th value should not be selected" is not possible, when you select more than three items from slicer,it only throws an error message.
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
5 Replies
v-juanli-msftCommunity Support
Hi Anonymous
I'm not clear about the statement "both the features 1. Force Selection 2. Max. limit of selection in one visual",
Could you show an exmaple with screenshots or data to illustrate that?
Best Regards
Maggie
- v-juanli-msft
Hi Anonymous
You could set a default slicer by "ChicletSlicer" visual,
go to https://app.powerbi.com/visuals/ and download "ChicletSlicer" visual.
Once you download it select visualisation under settings change Forced option to On.
"If they select more than 3 values it should throw some error message",
This can be done by creating measures:
Selected Count = if(ISFILTERED(Sheet3[ItemId]),CALCULATE(SUMX(VALUES(Sheet3[ItemId]),1)),0) Message = if([Selected Count]>3,"Please Select Only 3 Values"," ")
Add "Message" in a card visual, turn "Category' off,
But "the 4th value should not be selected" is not possible, when you select more than three items from slicer,it only throws an error message.
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- v-juanli-msft
Hi Anonymous
Is this problem sloved?
If not, please let me know.
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.