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.

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.

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 visibility of code, allow tests to be run - such as moving DAX calculated columns with M

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

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 columns in a calendar table as "do not summarize" by default and allow the user to change truly additive days (like isWorkingDay) to SUM when required. Even better, use the AI capabilites of Azure to work it out.

This idea was mentioned by Jeffery Wang in a meeting at the end of the MVP Summit 2019. No doubt Jeffery has his own ideas of how to execute this. It is a great idea and would add a lot of value to the majority of users.

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…

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 e.g. Total Sales = SUM(Sales[SalesAmount])
3. Select the created measure in the "FIELDS" pane or just click inside the formula bar > Open the "Home Table" list from the modeling ribbon and select a table
4. When done, right-click on the "Id" columns and select Hide
5. Now, Power BI will change the Icon from Table to Measures. How nice!

Happy PowerBI-ing,

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…

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.

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

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).

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.

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.

When I add an image to Power BI Desktop, the default setting is that the Aspect Ratio is not locked. This makes the process of scaling the image to a suitable size behave in an inconsistent way compared to (say) PowerPoint. If you turn on "lock aspect ratio", then the image scales correctly and consistently with other office applications.

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.

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)

Ready to get started?

Power BI Newsletter

Take your data to the next level with the best tips and tricks from our experts.

Thanks for signing up for the Power BI newsletter.

By clicking Sign up, you are giving your consent to Microsoft for the Power BI newsletter program to provide you the exclusive news, surveys, tips and advice and other information for getting the most out of Power BI. You can unsubscribe at any time.

Downloads

Whether you are on the go or need to create rich, interactive reports, Power BI offers you the tools you need.