Excel can do it.
SSRS can do it.
Why can't Power BI?
Thanks for all the feedback! We’ll consider this feature for a future release but no timelines to share just yet.
Yes, hard coded date values in a visual/filter is not proper data modeling. Power BI should know better than that.
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!
A situation that is not addressed by either method:
We have a custom, fixed fiscal calendar that will not work with relative date filtering.
Our weeks run Wednesday to Tuesday, for example.
I might be able to use relative date filtering for weeks, IF Power BI gave me a way to set the first day of the week to Wednesday. OR - if the relative date filter respected the date ranges in the calendar table.
The relative date filter also ignores the date range in my Calendar table and uses Today as the relative driver. So that means I can't use "last 7 days" either, as the last 7 calendar days have no data. (Data is refreshed weekly for prior week).
Sticky filters require users to make an initial selection, so that doesn't solve my issue either.
Currently, I can control the default slicer by republishing to the cloud with the slicer value pre-selected. But when I migrate to the Power BI Report Server - it will need a way to update the slicer choice.
3 votesaudrey abbey shared this idea ·
Thanks for the feedback! While this isn’t (yet!) on our near term roadmap, please keep voting and giving us feedback on the idea. We definitely see the need and will update the idea when we are closer to adding this feature.
Either the ability to hide the total column, or a way to change how the total bar aggregates.
The Ultimate Waterfall Custom visual costs money, just FYI. There is a free version but has many restrictions. I have enough licenses to manage without adding in individual visual licenses.