Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
In my dataset I have 16 rows divided into 4 groups (A, B, C, D):
I have a matrix visual with the subtotals for each group:
Is it possible to move all subtotals to the bottom of the matrix (so all subtotals are after the detail rows, and all subtotals are next to each other)? I would like to achive something like this:
Is it possible to achive this with the matrix? Or is there any other visual which allows to do this?
Solved! Go to Solution.
@Anonymous
I don’t think that is possible. But why not use the “collapse row” feature in the row header under the format pane?
Proud to be a Super User!
Paul on Linkedin.
@Anonymous
I don’t think that is possible. But why not use the “collapse row” feature in the row header under the format pane?
Proud to be a Super User!
Paul on Linkedin.
@Anonymous ,
I'm afraid a single visual we can't achieve this because we can not add specific rows in a visual. As a workaround, I would suggest you to create a measure [SubTotal] using DAX below and drag [Group] and [SubTotal] to a table visual.
SubTotal = CALCULATE(SUM('Table'[Value]), ALLEXCEPT('Table', 'Table'[Group]))
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
94 | |
83 | |
67 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |