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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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