Forum Discussion
Helper IHow to force select a value in dropdown slicer menu
Hi,
I have drop down slicer , lets say Prod A,Prod B,Prod C,Prod D. I always want atleast one is forecefully selected. the silcer should not be ALL by default.
Hi,marcelsmaglhaes and hansontm ,thanks for your concern about this issue.
Your answer is excellent!
And I would like to share some additional solutions below.
Hello,logan_logan .I am glad to help you.As suggested by hansontm and marcelsmaglhaes
If you don't want the data to be displayed in full by the slicer by default, you can try the following steps.
Here are a few steps you can try
1. Turn off the selected all option in slicer2. Modify the settings in Power BI Desktop to ensure that ‘Persistent filters’ is turned on when the report is published to service.
Power BI Service will default to display the final report was uploaded when the filter state, if your slicer in the final upload selected ‘A = 10’, and to ensure that this option is turned on, then other users to access the report in the future to see the default state of this slicer is ‘A = 10’
3. Try to use measure to control the slicer's default display results.This requirement often arises when you want the slicer to change according to the latest date and specify the default filtering effect of the slicer. (Users want to achieve the effect that when the slicer is unchecked, the table defaults to presenting the latest date data, and when selecting the options in the slicer, the slicer filtering effect runs normally.)
In this case, using the output of measure to control the data presented is a better approach.
I hope the following link is helpful.URL:
Solved: Power BI Slicer - Between Dates don't get the late... - Microsoft Fabric Community
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
hansontmResolver I
There is no perfect solution/feature for this, but you do have some options:
1. Turn off setting Show Select All. Select desired product in the slicer and publish. The default view for users will have this product selected, but they will be able to remove/unclick your selection to show all products.
2. Change to single select slicer. This may not meet the business need though.
3. Modify all your measures to display some sort of text like "Please select your desired product" when there is no product filter applied.
Will any of these options work? If yes, please mark as solved
- marcelsmaglhaes
Super User
Hey logan_logan
In Power BI there isn't a fully native configuration to force a slicer to always have one value selected. You need to use bookmars, DAX or use the single select slicer configuration.Using dax, if you want users to select multiple values but ensure that one value is selected by default, you can create a measure that will enforce a default selection behavior.
First, create a measure like bellow, then use this measure in your visuals or filters to reflect the default selection logic.
However, this approach won't directly modify the slicer's behavior but ensures calculations fall back to a default.SelectedProduct =
IF(
ISFILTERED('YourTable'[ProductColumn]),
SELECTEDVALUE('YourTable'[ProductColumn]),
"Prod A" // Replace with your desired default
) Hi,marcelsmaglhaes and hansontm ,thanks for your concern about this issue.
Your answer is excellent!
And I would like to share some additional solutions below.
Hello,logan_logan .I am glad to help you.As suggested by hansontm and marcelsmaglhaes
If you don't want the data to be displayed in full by the slicer by default, you can try the following steps.
Here are a few steps you can try
1. Turn off the selected all option in slicer2. Modify the settings in Power BI Desktop to ensure that ‘Persistent filters’ is turned on when the report is published to service.
Power BI Service will default to display the final report was uploaded when the filter state, if your slicer in the final upload selected ‘A = 10’, and to ensure that this option is turned on, then other users to access the report in the future to see the default state of this slicer is ‘A = 10’
3. Try to use measure to control the slicer's default display results.This requirement often arises when you want the slicer to change according to the latest date and specify the default filtering effect of the slicer. (Users want to achieve the effect that when the slicer is unchecked, the table defaults to presenting the latest date data, and when selecting the options in the slicer, the slicer filtering effect runs normally.)
In this case, using the output of measure to control the data presented is a better approach.
I hope the following link is helpful.URL:
Solved: Power BI Slicer - Between Dates don't get the late... - Microsoft Fabric Community
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.- DesireeS
Advocate I
In theory, there is a "force selection option" on the slicer
but it is currently not working, and if I understand the posts here, its been broken for at least a year.
My use case:
I have slicer A that filters the options of slicer B (but not the other way 'round). Slicer B is being filtered to the options I want, but none of them are "force selected", so everything else looks blank and awful. I am going back and forth between using a chiclet slicer instead (which does actually force select) or having a card under each chart that says "Please select from slicer B to view data". I started using PBI about 4 years ago and the chiclet slicer was the best option then and I am quite frankly surprised that it's still the best option now. I'd thought that Microsoft would see the value in the chiclet slicer and learn something.
