max value selected in date slicer

[Anonymous]

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)

[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.

[Anonymous]

Solved, Thank you.

[v-juanli-msft]

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

[Anonymous]

In a slicer, I want to set a default value and the user can select maximum of 3 values. If they select more than 3 values it should throw some error message and the 4th value should not be selected. Is it possible?

[v-juanli-msft · Accepted solution]

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.