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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.

Reply
Anonymous
Not applicable

Drill a summary matrix/table using measures (disconnected table)

I have a similar request to Solved: Building matrix/table using measures - Microsoft Fabric Community.

Though my requirements is to have column b in the matrix to be spilt or breakdown the measure by Period, Month and Year then have a grand total at the end.

maloba165_2-1726538039936.png

 


From above table to the one below. 

maloba165_1-1726537891258.png

 

How best can I achieve this with no relationship between my Projects table and the Dim_date as this information is all in excel for tracking purposes. Worth to note the different projects are measures calculated from different tables

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @Anonymous ,

 

(1) Prepare such test data.

vtangjiemsft_0-1726625979350.png

(2) Create a month column.

Month = FORMAT([Date],"mmm") 

(3) Create a matrix visual.

vtangjiemsft_1-1726626068415.pngvtangjiemsft_2-1726626083337.png

 

If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.

 

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

View solution in original post

1 REPLY 1
Anonymous
Not applicable

Hi @Anonymous ,

 

(1) Prepare such test data.

vtangjiemsft_0-1726625979350.png

(2) Create a month column.

Month = FORMAT([Date],"mmm") 

(3) Create a matrix visual.

vtangjiemsft_1-1726626068415.pngvtangjiemsft_2-1726626083337.png

 

If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.

 

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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