Forum Discussion
Subdivide row subtotal
Hello everyone. I am a beginner in using Power BI. I would like to implement the following report with the same caracteristics. But the thing at the moment is that I can't find any functionality that allows me to subdivide the row subtotals into two in order to get one row for the monthly total and one row for the cumulative total. Can you please give me an idea to solve this challenge? Thanks in advance for your input.
Monthly Total = SUM(Data[YourValueColumn])
Cumulative Total = CALCULATE(SUM(Data[YourValueColumn]), FILTER(ALLSELECTED(Data[Date]), Data[Date] <= MAX(Data[Date])))
Use a Matrix or Table visual from the Visualizations pane.
Drag your categories (e.g., Games, Guides, etc.) into the Rows field.
Add your new measures (Monthly Total and Cumulative Total) into the Values field.Adjust the formatting and coloring in your table to match the style of your original report. Use conditional formatting if needed to highlight specific values.
Test the slicers or filters to ensure that your totals update correctly based on user selections.
If this helped, a Kudos 👍 or Solution mark would be great!
Cheers,
Kedar Pande
www.linkedin.com/in/kedar-pande
2 Replies
Monthly Total = SUM(Data[YourValueColumn])
Cumulative Total = CALCULATE(SUM(Data[YourValueColumn]), FILTER(ALLSELECTED(Data[Date]), Data[Date] <= MAX(Data[Date])))
Use a Matrix or Table visual from the Visualizations pane.
Drag your categories (e.g., Games, Guides, etc.) into the Rows field.
Add your new measures (Monthly Total and Cumulative Total) into the Values field.Adjust the formatting and coloring in your table to match the style of your original report. Use conditional formatting if needed to highlight specific values.
Test the slicers or filters to ensure that your totals update correctly based on user selections.
If this helped, a Kudos 👍 or Solution mark would be great!
Cheers,
Kedar Pande
www.linkedin.com/in/kedar-pandeHi RaymondKEYA ,
Power BI does not support splitting Total into two rows for presentation, this is by design. You can choose to take the Kedar_Pande's approach and use two measures to calculate the two totals you need and put them into a matrix as fields for display, but note that this approach only allows you to have the two totals displayed as columns, not rows as in the diagram you gave:It will add Total here:
Best Regards,
Dino Tao
