We’re working on this! We’re adding controls so that you can force a slicer to allow a maximum of one value to be selected. Stay tuned, it’ll be available in an upcoming release.
Done in the March 2019 Update (2.65.5313.501). Shame it took 3 years from the raising of this idea ;-)
@Will Thompson - Excellent news. Hopefully a fairly simple quick win. Will there be a way of defaulting the selection that also takes RLS into account, ie default to first or last of the available options?
This is more of a bug report than a feature request, as a single select slicer exists but has been implemented badly.
Agree with other comments that the ability to unselect current option in a single select slicer is a bug.
Finally done in the March 2019 Update (2.65.5313.501)
Single selection now works as expected in the March 2019 Update (2.65.5313.501)
This has now been done in the March 2019 Update (2.65.5313.501)
As Gordon Kennedy says below, this is pencilled in for Pro at some point in the future. This has also been restated by Will Thompson at https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/7288623-incremental-data-loads
@Alexis Olson - Unfortunately that says what they have done, not what they are planning to do.
Absolutely need either a new Navigation pane, or the ability to put slicers on the Filter pane.
We’re looking into this request, thanks for everyone’s votes and comments.
It looks like many of the requests will be addressed by the new ‘Sticky filters’ capability. Now when you log out of Power BI and come back to a report, the same items will be selected as when you left.
For those who’re looking to have a ‘last month’ selection, the relative date slicer might help.
Those with comments about currencies where having multiple selected makes the report meaningless – the report will load with whatever selection the author saved, so if you save it with one currency selected your users will see that by default.
If there are scenarios that these features don’t address, please let us know in your comments – if you are really specific it’ll help us build the feature to work just the way you want!
As already mentioned, for lists and drop downs, there are two big issues at the moment:
1) If single select is enabled then you should not be able to unselect your item and have it show All. The slicer should force the user to select a different item.
2) For default values, sticky filters is not a solution as due to RLS different users may have different selection options. One possible and seemingly easy solution would be to have a 'default to first/last' option.
I am loathe to start a new idea when this is officially under review, so I hop these quick wins will be taken on board.
Sticky filter selections were added nearly a year ago. If you set the slicer to 180 days and publish, will this set the default for your users?
C'mon Microsoft. How about an update on this as a Christmas present? It is is pretty fundamental reporting requirement.
is there any news on this Microsoft? I fail to see how so many years down the line this still hasn't been implemented.
How can copy and paste features take preference over a fundamental reporting data type?
Is anyone from the Power BI team going to comment on this? How many of your users have a requirement to plot durations on a chart?
Unbelievable omission. Would anyone like to guess what an average elapsed time of 1443279 seconds is? Of course not, it's nonsense.
What is even more bizarre is that when you Edit Query there is a type of Duration.
Is there any comments from MS employees on progress of this feature, as without it Power BI is unsellable to our customers.
You also cannot switch between modes if you hide the header and show only the title, which seems like a UI design issue.
Support for fiscal calendars would also be extremely useful.
Excellent idea, although I'm not sure how you would configure the fiscal calendar start and end dates, how many fiscal weeks and months there would be, and how the weeks/months would be allocated to fiscal quarters.
Agreed. This seems an odd design decision.
The relative date slicer (a Preview feature as of June ‘17) gets us close to this with the ’This Month’ or ‘This Year’ settings. That is a dynamic date selection that updates based on the current system date. We plan to add a ‘YTD’/‘MTD’ option to specifically select a range from the start of the month/year up to today, hopefully that’ll address the remaining requirements!
Can you also add support for fiscal date slicing? This is pretty fundamental in the corporate world.