The formatting options for Matrices are very limited at the moment. We are missing key features including: 1) Matrix Values. In the Field Formatting, we should be able to format the Background and Font colors for the field Header, Values, Subtotals & Totals independently of each other. Currently, you can only select one color, and have to enable the same color for either of the options. Conditional formatting "fx" options would also be great here. There are creative workarounds with using conditional formatting to alter the Values/Subtotals colors independently of the field Header color, but we shouldn't have to rely on this for something that should be a basic feature. 2) Column Headers. Currently you can only select one Background/Font Color for the Column headers. We should be able to select different colors for each Hierarchy level in the Column field, and we should have "fx" conditional formatting options too 3) Grand Total Column should be visible at all times (much like the Rows Grand Total), regardless of the scroll position, or we should have the option to switch this on. Currently, you have to scroll all the way to the right to see your Column Grand Total which is unfeasible for the end user. 4) Allow multiple row headers (in separate columns) without forcing a Hierarchy. End users often want more detail on the row within the same hierarchy level. I know this is technically possible by disabling the "Stepped Layout", but currently this makes you lose your Rows Grand Total, and also drilldown on Rows is enabled regardless, and does not make sense in this scenario 5) Drill-on dropdown - allow us to set a default value for the dropdown to either Rows or Columns (currently rows by default) 6) Ability to sort the matrix by the lowest level of the hierarchy in the column headers, rather than just Total columns. For example, if I have months in the column headers, I should be able to sort the matrix Values for each month, by clicking on the desired month, and not be restricted to the Total for the months. Really a critical feature 7) Export the matrix data to excel in the same format, not in tabular format. Yes, we can easily pivot the data in excel, but end-users are often unable to do this.
1 Comment
- fbcideas_migusrNew MemberStatus added:Needs Votes
Recent ideas
Visual Type Defaults in Visualization Pane
This would change my life with fussy clients and client/public facing apps. In addition, it would allow me to add more value to the clients on retainers who do not have the 'hours' to allocate to...IolaWhiteley57 minutes agoAdvocate INew10Views2likes0CommentsMatrix: column totals as a bar chart docked to the edge
What's missing Data bars already work on the Total row and column through conditional formatting, so row totals can be read as length. Column totals cannot: they render as a horizontal bar inside a ...Sayurivalente1 hour agoRegular VisitorNew76Views6likes1CommentAllow Bookmarks to Affect Multiple Report Pages
Description: I would like to request the ability for a single Power BI bookmark to affect and maintain a state across multiple report pages, rather than being limited to a single page. For example,...Josegonzalez211 hour agoNew MemberNew18Views4likes1CommentFeature Proposal: Expandable/Collapsible Page Sections for Reports on Same Semantic Model
Subject: Feature Proposal: Expandable/Collapsible Page Sections for Reports Using the Same Semantic Model Dear Microsoft Power BI Team, I would like to propose an enhancement to the Power BI report...Dr7awb1 hour agoNew MemberNew29Views1like1CommentTable Visual — Rounded Corners and Pill-Style Cell Backgrounds
Add the option to display cell background colors as rounded rectangles or pill-shaped labels within the native Table visual. Currently, applying a background color fills the entire cell with a solid...urawizardharry1 hour agoRegular VisitorNew22Views1like1Comment