Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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)
Solved! Go to 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.
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.
Solved, Thank you.
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
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?
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |