Power BI Ideas
-
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.
3,754 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!
-
No Ctrl-Click on Buttons Needed for Bookmarks View Mode
When editing in Desktop, you have to Ctrl-Click a button to trigger the assigned action - very good. But when you have multiple bookmarks and you go into "View" mode, you are effectively in "PowerPoint Mode". When in this mode, there should be just a single click for a button (no ctrl needed).
713 votes -
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,441 votesThis is in our backlog. Stay tuned for more updates!
-
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).
4,814 votes -
Option to use comma as list separator and dot as a decimal point regardless of locale settings
Power BI Desktop has an editor that modifies the DAX code trying to respect the locale settings. This creates a number of issues in certain combinations of locale settings; because of that, there are bugs that have never been fixed when you have certain expressions
Moreover, respecting the syntax using locale settings creates additional issues when you copy/paste formulas in other tools that might not use the locale settings (not to mention community forums!).Please, consider adding an option to Power BI Desktop to use the standard comma (,) as list separator and dot (.) as decimal point for DAX…
265 votes -
Dark Theme/Alternate Color Desktop Themes
Enable a dark/black/gray theme for the various versions of BI; to enable ease of use.
715 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,994 votesGreat idea! Keep the feedback coming – we’ll update this item as we make progress.
-
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,163 votes -
Customize visible items in new filter experience
The standard slicers have now a visual level filter, but the new filter experience does not have a similar feature. A correspondent "visual level filter" allowing to define conditions that make an item visible or not. in the new filter experience. The reasons are the same that justified visual level filter in standard slicers.
380 votes -
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,778 votes -
Create model KPIs in Power BI Desktop
KPIs can be defined in the Analysis Services model hosted by Power BI, but there's no UI to create them in Power BI Desktop.
The icon sets feature (https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-july-2019-feature-summary/#iconSets) lets you define indicators with logic in the visual itself, but having that logic centrally defined in a model KPI lets you re-use it across visuals and even reports.
201 votes -
Ability to display all type of data details in tooltip or tooltip page for Stacked/Clustered Bar/Column Charts
The default tooltip only shows one type of data details when the bar/column is browsed, as well as tooltip page with Keep all filters toggle on. It will be difficult to read when each type of data is very narrow in the bar/column. It will be great to have a feature which tooltip or tooltip page is able to show all type of data details of the bar/column which is browsed.
38 votes -
Add Quick Access Toolbar to new Ribbon, or at least Save/Undo/Redo
The new ribbon introduced as a preview in the Nov 2019 release is really good, but it got rid of the Quick Access Toolbar that gave us persistent access to the Save, Undo, and Redo buttons no matter what ribbon was showing.
Now, there is no save button, and Undo/Redo are in the Home ribbon only, so you cannot access them with the mouse from the View, Modeling, or other ribbons.
48 votes -
Composite models when connected to SQL Server Analysis Services Tabular (SSAS)
We really love the new feature of 'Composite Models' in the Power BI July 2018 update! This enables us to join custom lists with DirectQuery sources.
It would also be beneficial if this would also work when connected to SSAS Tabular in DirectQuery.
This would stronlgy improve the enterprise features of Power BI.1,379 votesHello Avi,
Can you send me email so i can connect w/ you w the team?
Thanks
Chuck -
Allow for rectangular imageUrl sizes in matrix and table visuals
Currently when you use a column or measure with a category of imageUrl that has an svg image Power BI ignores the aspect ratio defined in the view box for the image and draws the image in an arbitrary square. It would be great if imageUrl would allow for rectangular images. In the case of svg this could be read from the viewbox attribute.
This would allow for the creation of dynamic databars and sparklines and other creative visualizations without having to write a full blown custom visual.
40 votes -
Measure-driven DataLabels
We need to be able to label specific data points with dynamically generated values (including text). Use cases include:
* Labeling the first or last point of line charts with values
* Labeling the last point of series in a line chart with the series name, to directly inform the user which series is which, rather than have them constantly move their eyes between a legend and the many series on a graph.
* Labeling particular values of interest, to aid storytelling.These things are bulk-standard features of good dashboard design, and are essential in order to design optimal user-friendly…
32 votes -
Perpetuate the table/query structure in a data model to Power BI Desktop when using a data model as a source for thin report writing
When building reports (what we call "thin" reports) in Power BI Desktop from an existing data model (used Power BI Dataset option for the Get Data to retrieve a data model), we need the table/query structure from the model to be the way the table/query structure in presented in the Fields section within Power BI.
For example:
In Query Editor within a data model a table/query structure may look like this:Order Subject Area [5]
Order line
Unified Order
Standing Order
Unified Order Line
Order ReconciliationShipment Subject Area [3]
Shipment Number
Shipment Status
Shipment ReconciliationWhen this model is…
23 votes -
Better Handle Column Types on Load in Dimension Tables
When you load a dimension table (say a calendar table) in Power BI desktop, there are often lots of numeric columns that are not additive. Examples include Year, Month Number, Day of Week etc. By default (unless you set the data type to text) these numeric columns will have the default aggregation behaviour set to SUM. But they are not additive (of course). It would be much better to set these (dimension numeric columns) as "do not summarize". This could be managed in various ways that would be better than the current state. eg, you could simply mark all numeric…
206 votes -
Allow the definition of ambiguous data relationships when creating data models & force the super user to select the desired relationship
This is a feature that other BI tools like SAP provide, but PBI does not allow it.
When creating relationships in a data model, PBI does not allow you to create an ambiguous relationship. We need to be able to create ambiguous relationships in a model. When a super user (report writer type) uses data associated with an ambiguous relationship, they should be prompted to choose the relationship they desire for their report.
23 votes -
Allow 'Search' within slicer filtering for non-text attributes
Text attributes can be 'searched' within report slicers. However, integers cannot. For example, if someone wants to quickly find and slice by a Customer Id, it is very cumbersome right now - lots of scrolling. A simple search by Customer Id (as an integer) within the slicer would make it much faster and a better user experience
540 votes
- Don't see your idea?