Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon'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.
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!
Just wondering, were you able to achieve the above requirement? I have the same issue right now!
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...
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
146 | |
75 | |
64 | |
52 | |
47 |
User | Count |
---|---|
218 | |
87 | |
71 | |
63 | |
60 |