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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
cas_724
Frequent Visitor

Adding a Standalone Column in a Matrix

Hi -

I am trying to add a standalone column in my matrix and am having a difficult time figuring out how to achieve my end goal.  I have a table that has employee names, their number of calls, their goals for each week and a calculated % of where they were to their goal.  There could also be transfers that are entered manually in a separate table, just name and # of transfers, not assigned to any week, just to be added at the end.  I would like to add this column to the end of the matrix as shown below (yellow column) but am not sure how.  When I try adding it, it populates in every week grouping.  I've tried adding it as a row, but it is not giving me the desired effect and I'd really prefer it be at the end if possible.

I was hoping maybe someone had run into this issue before or might have a way to solve it.  Thanks in advance!

cas_724_0-1705544644835.png

 



3 REPLIES 3
Deeins
Frequent Visitor

Just wondering, were you able to achieve the above requirement? I have the same issue right now!

lbendlin
Super User
Super User

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

Apologies for not uploading a useable data set.  I've recreated some bare bones tables.  I'm able to get everything accomplished with the exception of the transfer column in the first screenshot.  The Power BI weeks will be dynamic, as weeks go by in the year, a new set of 3 columns will be added for that week (Monday it will have the week of 1/22 data added).  I need the transfer column to always be able to be at the end of the other data.  Please let me know if you need anything else.

Below is the Google Doc link:
https://docs.google.com/spreadsheets/d/1M8HN4xTh_nB4_fshhxovLQoL0s2ynlF5/edit?usp=sharing&ouid=10985...

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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