Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
rsbin
Super User
Super User

Help with Matrix Totals....again

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:

rsbin_2-1679337807933.png

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

rsbin_3-1679337873152.png

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:

rsbin_4-1679339640185.png

 

Thanks and regards,

 

 

 

 

 

 

1 ACCEPTED SOLUTION

yeah, I would go with your two visual approach.

View solution in original post

6 REPLIES 6
lbendlin
Super User
Super User

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

@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.

which two annual totals are you referring to?

 

lbendlin_0-1679500553985.png

 

@lbendlin ,

Looking to split out Total 2022 vs Total 2023.

yeah, I would go with your two visual approach.

@lbendlin ,

Much appreciate your time and thoughts on this one!

 Kind Regards,

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.