Power BI Ideas

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

Read more...

692 Comments

Read more... 692 Comments

Administrator

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

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

Read more...

115 Comments

Read more... 115 Comments

Administrator

Checking with Will Thompson and moving status to backlog

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)

Read more...

201 Comments

Read more... 201 Comments

Administrator

Thank 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!

A current limitation in Power BI SWITCH measures (and all Power Pivot actually) is that a SWITCH measure must have a single format. It is currently not possible to conditionally format the measure result based on any criteria - it is one single format only. There are valid use cases where you m...

Read more...

70 Comments

Read more... 70 Comments

Administrator

From the comments and scenarios everyone's describing, the problem is really that you need a way to allow end-users to change which measure is displayed in a visual on the fly. As a few folks have mentioned, the FORMAT function might help in the interim, as long as you're showing the results in text rather than a chart. https://docs.microsoft.com/en-us/dax/format-function-dax has details on how to use that. The expression-based formatting feature that we've started work on may help to a certain extent, but that's really designed to change a visual's properties rather than the data type or format. We'll look into extending that work to support this scenario as well. We're moving this to Backlog status - our core plan is to build ways that end-users can change the dimensions or measures that are visible in a chart on the fly. They'll be able to explore much more freely rather than relying on the author to have set up complex expressions to control what's available. We'll update with more details as they're available.

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

Read more...

386 Comments

Read more... 386 Comments

Administrator

We'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!

Connecting to Excel workbooks in OneDrive is a great first step, but connectivity to Google Sheets should be there too.

Read more...

382 Comments

Read more... 382 Comments

Administrator

Thanks for the suggestions! I've split out the other cloud storage options into separate ideas for people to vote on.

It would be great to conditional format a table and/or a matrix based on the cell text, not only numbers

Read more...

133 Comments

Read more... 133 Comments

Administrator

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

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

Read more...

227 Comments

Read more... 227 Comments

Administrator

Hi everyone. This is something we'd like to get to in the future but don't have any plans for at the moment.

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

Read more...

130 Comments

Read more... 130 Comments

Create an a connection withrowgh Office 365 Planner and Power Bi.

Read more...

279 Comments

Read more... 279 Comments