Help with Matrix Totals....again

[rsbin]

Good Afternoon All,

Have searched for a solution for my scenario, but haven't quite been able to arrive at the solution I am looking for.
Have the following Matrix:

Achieved using the following set up where AllTimeWorked is a SUM of two other more detailed Measures:
( i.e.    [Measure1] + [Measure2]   )

As is the case, User only requires Totals at the Year Level - not per month.  So need to show YTD totals for each 2022 and 2023.

Because I am using only 1 Measure with necessary filter context, turning Subtotals on only provides one Total.

User can get to yearly totals by Drilling Down, but searching for thoughts, suggestions and hacks where I can show the two yearly totals in the same visual.

Is there a "cleaner" way of showing something like this:

Thanks and regards,

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

[rsbin]

@lbendlin ,

Thanks for the response.  Yes, I should have included some sample data.....

Department	All Time Worked	MonthName	Year
A	640	January	2022
A	1184	January	2023
A	616	February	2022
A	1112	February	2023
A	456	March	2022
A	832	March	2023
B	1804	January	2022
B	2011	January	2023
B	1903	February	2022
B	1896	February	2023
B	1362	March	2022
B	1133	March	2023
C	2151	January	2022
C	2168	January	2023
C	2122	February	2022
C	2103	February	2023
C	1762	March	2022
C	1486	March	2023
D	1411	January	2022
D	1210	January	2023
D	1251	February	2022
D	1113	February	2023
D	1024	March	2022
D	769	March	2023

The actual data is at the Employee Level by Day, but think providing summary data should suffice.

I am connected to a Calendar Table where I use a Flag to filter Calendar Days for PriorYear and CurrentYear.

What I am looking for is a way to show only the two Annual Totals in the same Visual as the Monthly values.

The closest I have got so far is to show as two separate Matrix visuals.

Thanks again and appreciate any guidance you can provide.

[lbendlin]

which two annual totals are you referring to?

[rsbin]

@lbendlin ,

Looking to split out Total 2022 vs Total 2023.

[lbendlin · Accepted solution]

yeah, I would go with your two visual approach.

[rsbin]

@lbendlin ,

Much appreciate your time and thoughts on this one!

 Kind Regards,