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).
New Desktop app update installed an almost white user interface. There is zero contrast which is not good for the eyes. I see where some people have requested a light interface so incorporate an option to select either light or dark theme like in the Office apps.
Add security to show/hide any specific page (Tab) on a report based on users privileges / Roles.
Here's an example of this custom navigation experience:
You can start by hiding all pages on your report except the landing page. Then you will create a column that contains the exact names of the pages in report.
Here's an example:
Using Power BI's row-level security feature, you can define the security roles and rules for this column, and then you can add the column to a single-select slicer.
The slicer will only show values in the column based on the security roles and rules that you've applied to this column.
Next, you can create a page navigation button and click the fx button to conditionally format the destination based on the column:
Now the button can navigate the user to the selected page:
Can we add sparkline support to tables and matrix? Native Excel PivotTable supports it. http://www.tips-for-excel.com/wp-content/uploads/2011/07/Picture117.png
We're in the process of planning and developing the feature! Look out for it in the coming months.
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...
We've been leaning on the community tools like Tabular Editor, DAX Studio, BISM Normalizer, to provide high-end DAX editing capabilities. We don't have any short-term plans to add more DAX management tools to the product, but we'll be looking at ways to better integrate those tools.
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...
We have this feature request in our backlog . Updates will follow.
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)
Update March 2021: we are actively looking into incoporating this feedback for workspaces and apps functionality. No timeline or definitive answer yet but we are aiming to adress this feedback soon. Since we do not have a targeted release yet, setting the status to 'under review'.
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...
In the interim, the FORMAT function might help, 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...
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!
It would be great to conditional format a table and/or a matrix based on the cell text, not only numbers
Administrator