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
Access Variable Library in Semantic Models
Enable the Variable Library as a centralized location for storing all environment‑specific variables, allowing us to adjust them for promotion scenarios (e.g., from dev to prod) without relying on de...FreddyH9 hours agoAdvocate IINew920Views31likes2CommentsEnhance Fabric Pipeline Monitoring with Parent-Child Pipeline Lineage and Parameter Visibility
Currently, Microsoft Fabric Pipeline monitoring lacks several capabilities that are available in Azure Data Factory, making troubleshooting and operational support challenging in enterprise environme...dwramreddy10 hours agoRegular VisitorNew8Views0likes0CommentsDynamic 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_db14 hours agoNew MemberNew238Views2likes2CommentsReintroduce 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_Ku17 hours agoNew MemberNew106Views14likes1Comment