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).
1,277 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.
809 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.
449 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.802 votesHello Avi,
Can you send me email so i can connect w/ you w the team?
Thanks
Chuck -
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.128 votes -
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.
3,418 votesChecking with Will Thompson and moving status to backlog
-
Organizing Measures into Categories using Folders
Adding few measures to your data model in PowerBI could be easily managed, but what about adding tens or even hundreds of measures! Organizing those measure into categories using folders could help a lot.
To show you what I exactly mean, I will demonstrate the alternative way to create those folders using empty tables:
1. Select "Enter Data" from the Home ribbon > Change the column name to "Id" and choose the table name e.g. "_Financial Measures" (Create all the tables)
2. Select "New Measure" from the Modeling ribbon (Or choose any shortcut) > Type and create a new measure…715 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…
89 votes -
Move Measures Between Tables in New Modelling View
The new Modelling View was delivered in Nov 2018 and is fabulous. There is already a button to select all measures in a table - great. I would like to then move all the selected measures to another table, either by drag and drop or by selecting the home table in the properties list (just like you can do for formatting).
235 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
234 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…
99 votes -
Power BI collaborative development
allows multiple developers to work collaboratively on the same PBIX.
Idea could be separate back-end (advanced editor) and fron-end (modelling and report design) or allows the possibility to merge more than one pbix.
609 votes -
Default measure format to comma and zero decimals
Every time I create a measure I have to format it as “,” and 0 decimals. This appears to be the most common format and it would make sense to make this the default.
207 votes -
Eraser for Search in Slicer gone if Header hidden
if you turn off the Header for a slicer with text in the field, the eraser vanishes from the Search box so there is no way to clear it. Turning on Titles doesn't fix it either. You must leave the Header on.
Seems like a bug.
339 votes -
Organization Approved Themes
Now that themes are out of preview and the Product Team has included themes in the Desktop tool the next thing to add to this is to have a section for organization approved themes. Since many companies have branding guidelines this would be an easy way for admins to load these themes and allow end users to pick from them to create consistency.
189 votes -
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
1,321 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.
-
Protect .PBIX with password
Allow to protect a pbix file with a password.
84 votes -
Report page tooltip on all objects
New report page tooltip preview feature in the March update is great.
Would be nice if we had the option of adding this tooltip to visuals that previously didn't have a tooltip.
For example, I have a card visual. I'd like users to get one of these mini report pages pop-up when they hover over it but as this visual doesn't have a tooltip it can't be used.
Would be great if we can do this on other things like shapes and text boxes as well.
448 votesSince the initial release, we added support for table, matrix, and cards.
https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-july-2018-feature-summary/#tableTooltips
https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-september-2018-feature-summary/#tooltips
I’ll leave this idea open for now since there are some requests for shapes, textboxes, and buttons, but it would be helpful if people can comment on their use cases for report page tooltips on these non-visual report elements.
-
Click and Drag to Select Multiple Objects and Allow Nudge
Similar to the other Microsoft products, it'd be great if we could click and drag the mouse to select multiple object on a page. Then, once multiple are selected, allow us to nudge them with the arrow keys all at the same time. Right now, we have to click one at a time and nudge one at a time. Oftentimes, I have many items I've already spent time aligning and then I need to nudge them and I have to do it one at a time.
155 votes -
(Real) Dual axis charts
It would be nice to be able to create dual axis charts and not the combo chart, to be able to drop more than one value on an axis and synchronize those axes. It would also be good to be able to control the type of mark in this instance so you could have one bar and one hash mark. Stephen Few would be happy cause we could create bullet charts (yeah those custom visuals really don't work and have bugs)
136 votes
- Don't see your idea?