Matrix subtotal

[Anonymous]

Hi !

I have a Year-Month slicer and I would like to show my YTD sales value. For example, if 2021-March is selected, it will show the sales value from 2021-Jan to 2021 March.

I'm afraid that I'm unable to show a screenshot of my matrix in Power BI, but it looks like the top table in the picture below. Any idea on how can I get it to look like the bottom table? I would like the totals for the 3 months to appear right after each sales category (Sales, Backorder, Orders on hand etc.).

Thanks in advance!

[amitchandak · Accepted solution]

@Anonymous , I doubt the below one is possible. The workaround is: You have convert measures to rows, take column of measure on the top of month in matrix

refer if needed

column header grouping
https://www.daxpatterns.com/dynamic-segmentation/
https://community.powerbi.com/t5/Desktop/Matrix-Display-Values-above-Columns/td-p/256905

[v-shex-msft · Accepted solution]

HI @Anonymous,

I'd like to suggest you take a look at the following blog to know how to use if statement to check current row content level, then you can use DAX expression to replace specific cell results.

Clever Hierarchy Handling in DAX - SQLBI

Regards,

Xiaoxin Sheng

[amitchandak · Accepted solution]

@Anonymous , I doubt the below one is possible. The workaround is: You have convert measures to rows, take column of measure on the top of month in matrix

refer if needed

column header grouping
https://www.daxpatterns.com/dynamic-segmentation/
https://community.powerbi.com/t5/Desktop/Matrix-Display-Values-above-Columns/td-p/256905