Power BI Ideas
-
Matrix +/- Collapse/ Expand Buttons
Please add Collapse/Expand buttons in the Matrix Visualizations. Otherwise when all fields are expanded by default the user would have to scroll a lot to find what they are looking for. I could add a slicer to take user to the data they are looking for but then the rest of the data in the matrix disappears and more specifically the overall totals change!Expand/Collapse buttons would keep the overall totals as intended and totals for other fields while allowing the user to only expand the field they are interested in. Also ability to do conditional formatting for a specific field…
3,582 votesIf you were at our Microsoft Business Applications Summit, you might have seen Amir and Will demo this feature! We are actively developing it now, and while we do have some more work today before it releases, the release isn’t too far off in the future. You can watch the session they demoed it in here: https://www.microsoft.com/en-us/businessapplicationssummit/video/BAS2018-204
-
Decomposition Tree Visualization Type
Multiple requests from groups that would like to see a decomposition tree. Typically they are from Proclarity/PerformancePoint world.
3,546 votesHey everyone! I’m updating this suggestion to “backlog” to better indicate it’s current state. We really want to do this and it’s definitely on our backlog to do. However, we aren’t currently planning or working on it, as our focus right now is on a couple of other “bigger” investments, such as printing to PDF in Desktop and expand and collapse on matrix row headers. I will update the suggestion again when we start planning the feature, and in meantime, please do keep voting and commenting. Thanks again for your patience and feedback!
-
Global filter in dashboards
Allow me to pin a filter to the dashboard that can be associated with one or more pinned dashboard KPIs.
3,478 votesHey everyone – just wanted to post an update and say that this work item is still in our roadmap. We are focusing our efforts in enabling other critical features related to filtering such as personal bookmarks in the Power BI service. Thanks again for patience and feedback!
-
scheduled export of a report to pdf
It would be nice if there is an option to have a scheduled export of a report to PDF. A nice to have feature would be to directly e-mail it to people so they are being notified of the latest report.
3,344 votesThanks everyone for your votes. We’ve started to do work this semester to light up this feature. Stay tuned for updates!
-
When will the KPI Red/Yellow/Green Indicators be available on PowerBI Desktop?
KPI Red/Yellow/Green Indicators were available in Power Pivot. With the new Power BI Desktop this feature is not available anymore. If you import from PP to the Desktop it converts the RYG Indicator Dots to a number. Will the Red/Yellow/Green Indicators be added back to PowerBI Desktop? If so When?
3,253 votesWe are considering this for a future release of Power BI Desktop. Keep voting and we’ll update this item as we make progress.
-
Incremental Data Loads
Is it possible to add incremental load functionality to Power Query? Pull and load just new or changed rows from source system
3,184 votesWe’re pleased to announce that in the May release of Power BI Desktop you can now define incremental refresh policies for your models.
At present these only apply once the model is published to a Premium workspace in the Power BI service; we’ll be bringing it to all Pro users in the future.
You can read more about it in our blog here: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-may-2018-feature-summary/#incrementalRefresh
We’re going to leave this idea open for now, so please give us your feedback while we’re in this preview phase!
-
Allow copy and paste between different PBIX's
Often we need to expand on an idea from one report further and copy and paste visuals/pages from one PBIX to another. This would be a huge productivity and quality benefit.
3,170 votesI wanted to let everyone know that we started planning for this feature! I’ll update the idea again once an engineer has officially started on it.
-
Tables in PDF files
I have come across so many public data repositories that hold data in PDF format. Other websites have tables within documents such as annual reports etc., also in PDF format. A data source for PDFs or tables from PDFs would be awesome!
2,952 votesThanks everyone for your feedback/votes!
We’re actively working on this new connector. You can find an early demo in the recording of the Power Query session at the Microsoft Business Applications Summit: https://www.microsoft.com/en-us/businessapplicationssummit/video/BAS2018-2167
Please stay tuned to the Power BI blog for further announcements.
-
can i sign in with my personal email login?
can i sign in with my MS outlook login?
2,684 votesWith the recent B2B Support for Power BI and the ability for Active Directory to support personal emails the the team is now unblocked to work on this feature.
-
Slideshow in Full Screen/TV mode
The ‘Full Screen mode’ could become more useful for presenting reports on dedicated large screens if it became just a bit more dynamic. Whilst it is currently possible to scroll through report sheets by clicking the arrows in the bottom right corner, it would be most valuable to be able to automate such browsing. A solution could be to introduce a “Play” button that starts a slideshow scrolling through the available report sheets according to a customizable time interval.
2,310 votesMoving from started to under consideration.
For reports please take a look at the Power BI mobile client (the Windows edition) -
Python Script in Power BI
It's great that Power BI already has the capability to run R scripts for data transformation. It would be even better if we could run Python script.
2,163 votesAnd now the preview is out! Read about our various integration points for Python here: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-august-2018-feature-summary/#python
We’ll close out the idea once we make the experience generally available in the coming months.
-
Measure Management & DAX Editor
Anyone who uses PowerBI long enough has had a PBIX with 50-60 measures and it has become time consuming and tedious to mantain. In Excel you can do a quick find/replace to edit several formulas - in PowerBI you need to select each one individually. An "excel-like" interface for editing measures would save a lot of time! This would take PowerBI to the next level regarding productivity. I've prepared a mockup for this as well as a DAX Editor. Let me know what you think.
2,125 votesCertainly a great idea. Please keep the votes coming.
-
Pass filters in URL
It would be great if we can pass filters in the url of the dashboard, which will filter the reports based on various parameters e.g. current fiscal period, geography, person's role, department etc.
1,982 votesHey all – we’re looking into how best to tackle this and other filter-related functionality.
If you have a few moments, please take the following survey to share your thoughts. The survey takes ~10 minutes to complete, and will help ensure that what we’re building meets your needs. We appreciate your feedback!
https://aka.ms/x998cx -
Export Report Server Power BI report to PDF
Please add the capability to export Report Server PowerBI reports to formats like pdf, word, powerpoint. Some of this functionality exists in the service but please add it to Report Server.
1,917 votesThanks for the feedback – we have this in our plans for the service and a future release of Power BI Report Server. I will update the status as soon as we’ve started work on this highly requested feature!
-
Integrate SSRS reports
Source dashboard reports from SSRS reports.
1,857 votesWe’re actively working on enabling SSRS (*.rdl) reports directly in the Power BI cloud service with no separate SSRS report server required. We want Power BI to be a one-stop shop for all your dashboards and reports, including Power BI reports, Excel workbooks, and SSRS reports.
It’s a large undertaking that’ll take some time, but as usual, we’ll start with previews to share our progress with you and hear your feedback, and expand the feature set and eliminate limitations over time.
We don’t yet have timeframes to share, but stay tuned!
-
Add Folders To Organize Reports On PowerBI.com
RIght now, on powerbi.com, there is no ability to organize reports, dashboards, etc into folders. If you have a lot of content or users, this gets messy quickly.
Please add the ability to organize into folders (and secure those folders separately)
1,696 votesThank you all for the feedback since our last update. We’re working on building a new navigation experience to allow authors to customize a folder-like structure for all the contents within Power BI Apps. Stay tuned!
-
Power BI Designer API
Power BI Designer saves a local PBIX file, which can be a file to export data and data model – in other words, it’s a format that contains a complete semantic model. All the applications that today export data in several formats (CSV, Excel, XML), might provide a richer semantic model exporting a PBIX file.
Many ISV/SI that have OLTP and other applications that stores data in some database, usually struggle to offer a compelling BI story to their customers. The smaller they are, the more they feel this pressure because probably the effort they can put in their custom…
1,603 votesHi everyone. There are some really interesting ideas in this thread, thanks for your vocal support about it! We’ll consider it for the future along with other suggestions and plans. Thanks!
-
Visual level filtering in slicers
I have a large set of options from which I would like to pick some specific ones and use them in a slicer to filter my data.
Currently, this is not possible while it is an implemented feature for other chart types.
I'm currently using a 100% stacked column chart as a workaround.1,586 votesThanks for the renewed interest, everyone! This is certainly something we would like to get to in the future, it’s down to a case of prioritization and working through some implementation details. Keep voting to help move it up our list!
-
Heat maps in Power View
It'd be REALLY nice to have heat maps capabilities in the map visualization of Power View, like those in Power Maps.
This is an OFTEN requested feature from our large enterprise customers
1,336 votesHi everyone. We announced a partnership with ESRI to bring their mapping capabilities into Power BI. Their maps include the ability to build heatmaps! The feature’s in Preview at the moment, I’m leaving this marked as ‘Started’ for now and we’d appreciate your feedback. Try it out and let us know how you find it. We’ll update it to ‘Completed’ when we take the Preview label off the feature.
More details on the blog: https://powerbi.microsoft.com/en-us/blog/announcing-arcgis-maps-for-power-bi-by-esri-preview/
Thanks!
-
Default Selected Slicer or Tile-By Value Configuration
Allow a user to set the default value for a slicer or tile-by value on a page/dashboard, so that when the Power View page is opened for the first time, the default value is selected.
eg. If the page has a slicer for Year or Month, allow the user to configure the most recent Year or Month to be selected by default.1,305 votesWe’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!
Thanks again!
- Don't see your idea?