Power BI Ideas
-
Add expand/collapse feature to column headers
Vote on this idea if you want expand/collapse on column headers in the matrix similar to what was shipped for row headers in November (https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-november-2018-feature-summary/#expandCollapse).
5,084 votes -
Paginated reports - please make it available in Pro as well as Premium
Paginated reports - please make it available in Pro as well as Premium .. thank you
4,972 votesThanks for the feedback and your vocal support about it! This is under discussion, so please keep voting this up and providing the feedback/examples of why this is so important to you and your organization.
-
Option to use either light or dark interface.
New Desktop app update installed an almost white user interface. There is zero contrast which is not good for the eyes. I see where some people have requested a light interface so incorporate an option to select either light or dark theme like in the Office apps.
5,137 votesThis is on our roadmap but we don’t have a specific timeline to share at this point. We’ll update this when we have more details!
-
Sparkline
Can we add sparkline support to tables and matrix? Native Excel PivotTable supports it.
http://www.tips-for-excel.com/wp-content/uploads/2011/07/Picture117.png
4,139 votesGreat idea! We’d like to add more visualization types in the future, and the votes that this item receives will help us prioritize them.
-
Allow Table and Matrix Data Exports to Match PowerBI Visual
I have volumes of information to share with my teams that is best presented in tables and matrices. It would be a huge improvement if they were able to export the data from the visualizations and have the formatting in Excel match the formatting created within PowerBI.
This would be especially helpful for ongoing forecasting activities.
3,848 votesThanks for your feedback on this issue – while we’d like to enable this, there is currently no timetable around doing so. There is the option as a workaround the create a paginated view as a drillthrough of the visual and have a formatted version you can export to Excel, but understand this isn’t a solution everyone can take advantage of currently.
-
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.2,998 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!
-
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)
2,951 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!
-
Connectivity to Google sheets
Connecting to Excel workbooks in OneDrive is a great first step, but connectivity to Google Sheets should be there too.
2,759 votesThanks for the suggestions! I’ve split out the other cloud storage options into separate ideas for people to vote on.
-
input fields
What about adding input fields to the dashboard widgets. Kind of like the text field but it is enabled for user input. This input field can be used in new column and new measure fields so that once the dashboard is set up the user can easily (without filtering) explore the data by entering different values such as if you had an input box for unit price. Then if you change it all the charts of total sales, revenue, etc. Will update to reflect what would happen if you increase the price by 10%. This will enable people to quickly…
2,524 votesHi everyone. This is something we’d like to get to in the future but don’t have any plans for at the moment.
-
Load data from Office 365 Planner to PowerBI
Create an a connection withrowgh Office 365 Planner and Power Bi.
2,435 votes -
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…
2,409 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!
-
Support creating calculation groups in Power BI Desktop
Support the creation of DAX calculation groups in Power BI Desktop - otherwise Power BI can only consume calculation groups created in Analysis Services, whereas it would be very useful to have this feature in any Power BI model.
Even just a simple text window with a script would be fine. You can clean up the UI later.
Thanks.2,293 votesThis is in our backlog. Stay tuned for more updates!
-
Conditional Formatting for Text
It would be great to conditional format a table and/or a matrix based on the cell text, not only numbers
2,055 votesThis month we added the ability to format text fields based off a numeric field: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-may-2018-feature-summary/#conditionalFormatting
We also are planning on adding a feature that will let you format your text based on comparisons. I’ll update this idea based on our progress on that feature.
-
When showing subtotals at the bottom, show the attributes there as well and not on top
When I choose the option to show the subtotals at the bottom, I expect to see the attribute name there as well and not just on top. This is especially crucial for financial statements, like shown here: https://wp.me/p6lgsG-YC
An option to toggle between showing attributes at the bottom only or at the top as well would be ideal.
1,866 votes -
Column Level Security for reports
Ability to define rules at column level, to control the data fields available to different roles (e.g. employee salary visible to the users in finance roles only, while other employee details visible to other department roles).
1,844 votes -
Show column data profile statistics in header
Add a column data profile histogram in the data view for every column in Power BI Desktop. This handy feature exists in Power Query (sometimes only on sampled data).
Add this feature to Power BI Desktop as well, please.
1,765 votesGreat idea! Keep the feedback coming – we’ll update this item as we make progress.
-
Clustered+stacked Chart
A column/bar chart with both clustered and stacked features (stacked clustered bar/column chart).
1,735 votes -
Slicer Hierarchy
Dragging a hierarchy into a report and change it to slicer... can we get a slicer with hierarchy (collapsible/expandable)?
1,729 votesHi everyone. With the February release of Power BI Desktop we’ve released a Preview of this feature! You can add multiple fields to the slicer and use expand/collapse to drill through the values in the hierarchy.
We’d love to hear your feedback on it – please add comments to the thread here if there’s other things you’d like us to add.
Thanks again for voting and giving us feedback!
-
No alignment options available in card visual.
Alignment option like (Center, Left or Right) is not available for data in card visual.
1,695 votes -
Built in Git support in PowerBI Desktop
When you create a PowerBI report in Power BI Desktop it transparently create \ use a git repository. So you just worked normally, then when you hit publish, it actually push to remote.
Gitignore could be used to exclude data from being published to the repository. PowerBI would have version control which is desperately needed.
This would work well with the whole Microsoft buying Github \ Azure DevOps, both from the perspective of promoting good practices such as code version control and CI\CD - process of developing in development and promoting to UAT\production
It would also allow IT to get…
1,643 votes
- Don't see your idea?