Ability to Collapse Individual Rows in Matrix Visual
I would like to have the ability to collapse individual rows in the Matrix visual in Power BI. Currently, we can only collapse or expand all rows at once per entire level. However, it would be highly beneficial if I could collapse specific rows within a level while keeping others expanded. (Same as in a pivot table in Excel)
One specific use case where this feature would come in handy is when I use a Matrix visual with a hierarchy of "Department" to "Type" to "Product". Within the "Type" field, there are two categories, namely "Supply" and "Demand". I would like to have the ability to individually collapse the rows with the "Type" "Supply", displaying only the subtotals, while keeping the rows with the "Type" "Demand" expanded with their respective details.
This feature would enhance the reporting experience by allowing us to hide specific details and display only the desired subtotals. It would provide greater flexibility and improve readability of reports with complex hierarchies.
2 Comments
- fbcideas_migusrNew MemberStatus added:New
- jeroenterheerdtMicrosoft EmployeeStatus changed:NewtoCompleted
You can already do this.
Recent ideas
Dynamic ADLS-Gen2 path input for Spark Jobs Main definition file
I would like the ability to add a dynamic input box on a spark job definition's "Main Definition File" "ADLS-Gen2 path". this would be useful to set base and variable paths across all spark jobs...mfink_db2 hours agoNew MemberNew234Views2likes2CommentsReintroduce Tenant/Capacity Switch to Control "Users can create Plan items" Post-GA
During the Preview phase of Fabric Plan items, administrators had access to a dedicated tenant/capacity setting: "Users can create Plan items". With General Availability (GA), this granular administr...Sri-Surendra_Ku5 hours agoNew MemberNew106Views14likes1CommentSupport Fabric SQL Database with workspace-level inbound Private Link
Fabric SQL Database supports tenant-level Private Link but not workspace-level Private Link. Securing a small number of databases therefore requires enabling Private Link across the entire tenant, in...WorkFull227 hours agoAdvocate INew12Views1like0CommentsImprove Relationship UI Wording to Better Reflect Filter Propagation Direction
The current relationship dialog can be confusing because the UI labels "From" and "To" do not always align with users' linguistic expectations regarding filter propagation. As per document : Relation...v-varunvv7 hours agoMicrosoft EmployeeNew20Views4likes0Comments