Power BI Ideas
-
Custom Viz access to the previous levels in a drill-down
The current version of Power BI visualsation framework does not support access to the previous levels in a drill-down. I.e. you only get access to the current level when rendering. That makes it very hard to develop visualizations such as pivot tables or breakdown trees.
This would let custom viz developers add thing like pivot tables and Breakdown Trees :)
[This idea was created as an offshoot of https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/15844186-pivot-tables-and-breakdown-trees. Fredrik had initially asked for updates to the Custom Viz API, but many votes and comments were cast assuming the idea was just asking for the Power BI team to…
7,547 votesThank you everyone for the comments and votes. We’re looking into what could be done here. To be transparent, so far our findings are that the infra to do this right for the long term is actually a very large intricate work item. So I cannot say when we could actually delivery this capability. Our current focus with custom visuals is to continue filling in the existing features into our stable APIs so that custom visuals are fully compatible version on version. This itself is vital work in the custom visuals area both for our custom visual authors/developers and for users who depend on the visuals day in and day out. Appreciate your using Power BI, keep the suggestions coming! We read every comment you make, even if we’re not able to respond to every single one.
-
Pivot tables and breakdown trees
The current version of Power BI visualsation framework does not support access to the previous levels in a drill-down. I.e. you only get access to the current level when rendering. That makes it very hard to develop visualizations such as pivot tables or breakdown trees. Make this possible and I would gladly submit a stable version of my Breakdown Trees :).
6,973 votesHi Y’all,
As Will mentioned, we have started work on new improvements to our table and matrix visuals. If you would like to help us prioritize some of the work we want to do, you can take this quick survey: http://www.instant.ly/s/x5whA Of course we are still reading all the comments on here as well.
Including Will’s last update here as well since everything is still relevant:
_____Hi everyone.
Thanks for all the vocal support for this idea! Firstly, some great and exciting news: we’ve begun work on adding more PivotTable-like functionality to our matrix & table. You’ll see conditional highlighting in matrices, selection & cross filtering, expand/collapse and more coming over the next few releases.
This Idea’s got a lot of comments for different things so I’d like to split it up to try and get a better idea of exactly what will help the most people:
- Fredrik’s… -
Subscribe *others* to emails of reports
Extend the email subscription feature, currently in public preview, to enable subscribing *others* to email snapshots of reports.
More information about the existing email subscriptions feature can be found here: https://powerbi.microsoft.com/en-us/blog/introducing-email-subscriptions-in-power-bi-stay-informed-when-it-matters/preview/
398 votes -
Dynamic date slicer
The new date slicer is awesome, but it would be so nice if you could set a dynamic date selection instead of a static. With a static filter the user will always have to set the dates before the saved report makes sense - especially as the report gets older.
Dynamic options could be
YTD, QTD, MTD, WTD, Today, This Year, This Quarter, This Month, This Week and so on.1,314 votesSomething we have certainly heard….lets see when we can get to it.
-
Dynamic Parameters for What if analysis
[Will Thompson] I've just merged a couple of very close scenarios, which all have similar great ideas! Something we're considering for the future, so I'm keen to hear your feedback on this. I like this core scenario of a numeric value that is bound to a slider control, and can then be used as part of some expression.
- In a sales report, I can adjust a '% increase' slider to see what impact a small change in revenue might have had on my sales.
- In a mortgage calculator, I can change the % rate, borrowed amount and term to see projected…941 votes -
Allow PowerBI mobile app to open local files
Hi, Power BI allows us to create great insights supporting our daily jobs. While we can use the desktop version in my company, we have a security issue with publishing to Cloud. Data protection is heavily focused.
To avoid breaking any internal rules on data protection, we would definitely benefit from option where PowerBI mobile would allow users to open local files without having them pushed to Cloud via Publish function in PBI desktop.
Viewing local files works great with Word/Excel/PowerPoint on mobile.
Thanks for considering / replyGab
205 votes -
Allow customization of email subscription schedule
Extend the existing email subscription feature to allow me to specify exactly *when* the email is sent out - e.g. send me the email at 2pm every Monday.
More information about the existing feature can be found here: https://powerbi.microsoft.com/en-us/blog/introducing-email-subscriptions-in-power-bi-stay-informed-when-it-matters/
227 votes -
Measure Dependency View (similar to the Query Dependency View)
The newly introduced Query Dependency view is phenomenal but what we really need is a Measure Dependency view. Here is what it might look like: http://ppvt.pro/2eXKndh
And a video detailing this idea: https://youtu.be/sYjBB_Ef66MIn one of my production models I have 60 Queries, but I have 200+ measures! I believe that is typical; usually I build Queries and Measures as lego blocks, combining simpler ones into more complex ones needed in the end. In fact I needed it so badle that I attempted to build a Measure Dependency view using NodeXL. While that works, it's a lot of heavy lifting.…
795 votes -
Subscribe to email snapshots of reports in *specific filter/slicer states*
Extend the email subscriptions feature, currently in public preview, to include support for email snapshots of reports in specific filter/slicer states.
More information about the feature can be found here: https://powerbi.microsoft.com/en-us/blog/introducing-email-subscriptions-in-power-bi-stay-informed-when-it-matters/
190 votes -
Power BI Embedded - Connection to Analysis Services Tabular
Please provide the ability to connect to Analysis Services (Tabular) from Power BI Embedded
149 votes -
javascript
Fix the dataSelected event to also provide **values** array retrieving data from an embedded powerBI report. Ref.: [https://github.com/Microsoft/PowerBI-JavaScript/wiki/Handling-Events] @ 2) ***values** array (In Progress)
317 votes -
Greater control over the scale and division of axes, especially values less than 1.
Greater control over the scale and division of axes. The MAJORITY of our data is frequency related where we have to display values in scientific notation from the range of 10-9 up to 10-2. Display of numbers greater than 1 creates automatic minor division on the y axis; but if below value of 1, the minor lines on the y axis do not display and there is no control over this. Same applied for x axis. Similar comments have been posted over greater control of the axes values and arrangement, but I have not seen one about small number values.
284 votesI know this is something Amanda and Kim are looking at…moving to under review status
-
Ability to create display folders in Power BI Workspaces
As Power BI becomes more widely used, the number of dashboards and reports in my workspace (and the group workspaces I'm a part of) are rapidly increasing. Within any workspace, it's overwhelming and confusing to navigate between reports and dashboards due to the sheer volume of items.
Please add an ability to create display folders in the Power BI service. Ideally these folders could contain reports, dashboards, and datasets - they would not be asset-specific. This would allow me to group content by subject areas or clients, rather than by content type. Within any given display folder, the content can…
599 votesThe entire workspaces paradigm is being looked at:
please see: https://powerbi.microsoft.com/en-us/blog/announcing-the-new-power-bi-navigation-preview/ -
KPI Icon sets for use in table and matrix visualizations
Many of the Power BI Community have come from a background of using Power Pivot in Microsoft Excel. Excel had a fantastic way of using built-in conditional KPI icon functionality to add impact and information to table and matrix visualizations. The red-yellow-green circle icon set is valuable as an easy-to-interpret indicator of whether something is on track (or not) against defined goals.
This functionality is glaringly absent from the Power BI Desktop. There was a previous request for tis that has been marked as “completed”, but it’s still missing.
432 votes -
Printing custom visualizations
It would be helpful to be able to print custom visualizations to PowerPoint. Currently there is just a message saying that the visualizations are not currently supported. Even allowing the visuals to be frozen in a picture format would be acceptable. Thanks.
135 votes -
Disable share buttons
Option to disable the share buttons (Twitter, Linkedin, Facebook and share itself) in the embed code. I am using the embed code to post the report in a sharepoint page with in the company by this would prevent a public sharing.
581 votes -
Use Power BI Desktop as a Local Server on a PC
It is possible to open Power BI Desktop, detect the port number, open Excel, connect to the running local instance of Power BI Desktop as a local SSAS instance and then build a pivot table over the local server. You can do this using DAX Studio.
This is very useful and as more people build Power BI Desktop files as the main data model, this will become more important. There is an "Analyze in Excel" feature in the Power BI Service and I would like to see the same for Power BI Desktop.
As a suggested approach to a solution,…
296 votes -
More flexible Conditional Formatting in Tables and Matrixes
More flexible Conditional Formatting in Tables and matrixes.
The current color customization in tables is very limiting. I need more than 3 color choices.
I should be able to add multiple values and assign colors to each.187 votes -
Power Query functions in URL using a web data source under on-premise data gateway
Add the ability to use Power Query functions in the source string not only for the PowerBI Desktop, but also to on-premise data gate
Now It's not supported to type Power Query functions as web URL when we create a web data source under on-premise data gateway593 votes -
Make downloading .PBIX only for Global Domain Admins
We and another develooer teams create PowerBo reports, build mesures and sell ready BI product to another companies.
Now everyone can buy one our report, download pbix file and sell our product.We, developers, can't now save our inteligance product.
Why users have permissions to download developer's tools?
We think, only Global Admins must have possibility to download PBIX
167 votes
- Don't see your idea?