When need a button to clear all filters on screen262 votes
Thanks everyone for your feedback. We recently announced Persistent Filters in the Power BI service. As part of this feature, we added a “Reset to default” button that clears all the filters users have applied on the report to the author’s published view. More details here: https://powerbi.microsoft.com/en-us/blog/announcing-persistent-filters-in-the-service/
The current drill through capability does not appear to consider an active filter/slicer value for a visual unless the dimension being filtered is included in the parent visual. I think it would be helpful if it did.
For example; a table of customers subject to a slicer for specific stores should pass on both the customer and store values if these dimensions are both listed as drill through filters.903 votes
As of the May 2018 release of Power BI Desktop you can now define your drillthrough to ‘Keep all filters’ which will apply the selections from slicers and other visuals to the target page as well.
If you have 2 visualizations that you are toggling through a Bookmark image, and have slicers on your page, if you change a slicer value and click on the image to toggle to a different viz, the slicers value will not be retained. For instance, if I select Canada in a slicer, click on the toggle, the slicer will change back to whatever was saved in the bookmark. It would be nice to have an option to "retain" the current selections. This would allow a user to make different selections in the slicer, and then when the click on the toggle button, it would retain those values instead of using the slicer value when the bookmark was saved.
If you have 2 visualizations that you are toggling through a Bookmark image, and have slicers on your page, if you change a slicer value and click on the image to toggle to a different viz, the slicers value will not be retained. For instance, if I select Canada in a slicer, click on the toggle, the slicer will change back to whatever was saved in the bookmark. It would be nice to have an option to "retain" the current selections. This would allow a user to make different selections in the slicer, and then when the click on the…269 votes
Hi y’all! Our December update to Power BI Desktop is out, and it has added bookmarking flexibility that should let you retain your filter/slicer state while still toggling visuals. Learn about it in my blog post: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-december-feature-summary/#bookmarkFlexibility
PowerBI needs to have the ability to offer conditional formatting of based on the comparison of 2 or more metrics. For example if metric A = metric B then change the font and highlight color of the cell to red.
If metric A > metric B and metric A < metric C then change the font and highlight color of the cell to green.
This should be unlimited for how many colors can be used. Other BI tools offer this feature.
Note that this is different than what PowerBI currently calls ‘conditional formatting’1,686 votes
As of our May release, you can now conditionally format a column by another field. Which means you can create a column that does your comparisons and then use that to format anything in your table or matrix. If you have other suggestions for conditional formatting options, make sure to vote on those as well!
As much as I like the new Drillthrough actions, it seems a bit lacking in that it does not also pass through any report filters that are active on the source report on the source report.135 votes
As of the May release of Desktop this is now supported! All filters (report, page, visual, slicers and cross-highlighting) can be passed through to the detail page.
Thanks for voting!
It would be great if it would be possible to pass filters in the URL of the report on the report server (as it is already possible in Power BI online)297 votes
As promised, we’ve added basic filtering of Power BI reports via URL parameters, similar to the Power BI service feature described here: https://powerbi.microsoft.com/en-us/documentation/powerbi-service-url-filters/.
For example, if you’ve embedded a Power BI report into another app using an iframe and a URL like the following:
Then you can specify additional filters using the “filter” URL parameter:
https://reportserver/reports/powerbi/Store Sales?rs:Embed=true&filter= Store/Territory eq ‘NC’ and Store/Chain eq ‘Fashions Direct’
Syntax: URL?filter=Table/Field eq ‘value’
The same restrictions that apply to the Power BI service apply to the Report Server as well:
- Table and Field names are case sensitive, value is not.
- Fields that are hidden from report view can still be filtered.
- Value has to be enclosed with single quotes.
- Field type has to be string.
- Table and field names cannot have any spaces.
In the usage metrics for dashboards and reports, show the names and/or email addresses of the end users.
FYI: The current usage metrics feature is documented here:
Hey all – we’re excited announce that this is now available. Read about it in our blog post:
Have feedback? Let us know in our community forums:
It would be great if we could embed the mobile optimized version of the reports that we see in the PowerBI mobile application in a custom mobile application. Currently my company is having to create a separate report that has a mobile layout and then embed that version into a custom mobile application.31 votes
we just released embedded support to mobile: https://azure.microsoft.com/en-us/updates/mobile-layout-support/
At the moment it is only possible to save a Power BI report with data source Analysis Services to the Report Server. With any other data source you get a error, that only Analysis Services is supported. Please add the possibility to save reports with other data sources to Report Server.202 votes
With Power BI Report Server (October 2017), released earlier this week, you can now:
- Import data from any Power BI Desktop data source
- Schedule data refresh or connect in “DirectQuery” mode for many of the most-used data sources (see data source support: https://powerbi.microsoft.com/documentation/reportserver-data-sources/)
Thanks to all of you who tried the August 2017 Preview and shared your feedback!
What we really need is a slicer (filter) to be available over all tabs/pages. Maybe create a user control which can be placed on each page? In this user control you can define multiple filters/slicers which are available on each page. Maybe a kindof pulldown menu for this user control so it does not take up to much space?188 votes
This is actually available now! You can use the Sync Slicers functionality to apply the selection made in a slicer to other slicers in a report. You can hide slicers on the pages where you don’t want it to appear, but it’ll still have the filter applied.
A typical website nowadays is responsive, but Power BI reports are not. Embedding them in a website might lead to a bad user experience on mobile devices. Embedding reports using the phone layout (or a similar responsive layout) would be great for use cases where mobile devices are targeted from the website.20 votes
drill into next level with a 2 sec touch or forcetouch.
or Drillthrough if defined for the control.
(it's not so sexy to make a drilldown today on a mobile
- double click for control focus
- select bar
- click "Show next level"
- click Back button)5 votes
we just released drill down for mobile.
It would be great if we could change columns labels/names in the standard visuals (Table & Matrixes mainly). In our company we have a data warehouse build to support the PowerBI tabular model with the data. The field names in the data model are not the most intuitive to our PowerBI End User. It could be great if we could change the way the field labels are shown in our tables to be more intuitive and meaningful without needing to change the field names in the data model.1,513 votes
With today’s release, you can now rename any field within a chart or table! Learn more in our blog post: https://powerbi.microsoft.com/blog/power-bi-desktop-july-feature-summary-2/#rename
In Power BI Desktop it should be posible, before publishing the file to the service, to mark some pages as "do not publish" or hide them for publishing. This way we can have some safe hidden place to draft new ideas or a repository of charts to copy to the pages that will actually be published.
The place to put this functionality could be the contextual menu that appears when right clicking the page name (now it shows "Duplicate Page" and "Rename Page". New option could be "Do not Publish")739 votes
You can hide pages so consumers of your report won’t see them. Learn more about this feature on our blog: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-january-2018-feature-summary/#hidePages
I've set a parameter in a report, published it, embedded it via powerbi js but I cannot set the value of the parameter......... sux :(1 vote
Enable scheduled refresh for the BigQuery connector11 votes
The "Publish to web" setting for portal administrators currently has the options of 'Enabled' or 'Disabled'. It would be beneficial to have this manageable in the same way as content packs so certain security (AAD) groups could be set as publishers.144 votes
Great news (and sorry for the late update). We added granular admin controls for Publish to web, so you can choose which of your users can create or are excluded from creating Publish to web embed codes. Just go to the Power BI Admin portal, expand Tenant Settings, expand Publish to web and you’ll see the options. Here’s the documentation: https://docs.microsoft.com/en-us/power-bi/service-admin-portal#tenant-settings
Currently File size to host on Power BI Report Server (on premise) is 100MB.
Please Increase the maximum file size to 2GB if possible.
1) I asked the question in the forum: https://community.powerbi.com/t5/Report-Server/Power-BI-Report-Server-Excel-file-size-hosting-How-to-Increase/m-p/260648
2) For SharePoint 2013, we can do like ... https://blogs.technet.microsoft.com/sammykailini/2013/11/06/how-to-increase-the-maximum-upload-size-in-sharepoint-2013/12 votes
Thanks for your feedback! With the Power BI Report Server update released earlier this week, we’ve enhanced the report server to support upload and storage of much larger files, increased the default file size limit to 1 GB, and allowed you to increase it further to 2 GB if you like.
Allows the PBI Admin to control creating of workspaces and apps from Power BI. We have end users who do wonderful things on their own, but when they publish Apps we have no way to vet and "certify" that they are sharing good data. Would prefer to be able to control what gets published outside of the "my workspace" area. Don't care if they share with others, but doing a new workspace and especially an App needs to be admin approved. With 5,000 employees we can't have 5,000 apps all called "Payroll" or "timesheet tracking" or "overhead"...22 votes
It's great that we can now provision Power BI embedded capacities in Azure, with the option to scale and pause them in the portal. However we really need to be able to automate scale-out and pause/start of these resources. Please make PowerShell cmdlets available to allow this.4 votes
We now have support for this API through PowerShell as well.
See latest blog post- https://powerbi.microsoft.com/en-us/blog/power-bi-developer-community-january-update/
- Don't see your idea?