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.
Agree with other comments that the ability to unselect current option in a single select slicer is a bug.
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.
I agree that this would be very useful. The default action of filtering is counter intuitive when clicking on the value header(s), and of course is a different action to selecting the totals.
Filtering only really makes sense when clicking on the column values above the value header(s).
Whilst a nice idea, it isn't the same as the roadmap I asked for at https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/33578731-publish-a-power-bi-roadmap
People can vote all they like, but it doesn't mean those items will get done. After all, it's not like we're living in a democracy.
Definately required. As it currently stands "See Records" seems great, but you soon find out how incomplete the implementation is.
As well as hiding, moving column, the ability to add columns from the same table(s) used in the visual is a requirement. For example I have a table with a measure based on a date field, but I can't see the date field in "See Records". Go figure!