Forum Discussion
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!
3 Replies
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-Forum/ba-p/963216
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/1447523Apologies 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=109857102226483034649&rtpof=true&sd=true
Just wondering, were you able to achieve the above requirement? I have the same issue right now!
