Forum Discussion
How to force select a value in dropdown slicer menu
- Anonymous1 year ago
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.
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.