Forum Discussion
Column sums by text work order numbers
I have a matrix and I would like to add the WO #s to my matrix. Once I add the text column it only give me the First number of the WO list. How can I add a text column of work orders numbers and have them displayed without it summing the column or only giving me the First or Last numbers of the WOs
Thank you all so much for the responses. I've came up with a "bandaid" method that's worked so far but I am curious to try some of the solutions above. I will try those solutions next week and provide feedback. Thank you all again!
9 Replies
Thank you all so much for the responses. I've came up with a "bandaid" method that's worked so far but I am curious to try some of the solutions above. I will try those solutions next week and provide feedback. Thank you all again!
v-aatheequeCommunity Support
Hi dpatrick1
Just following up to see if you had a chance to try the suggested solutions you mentioned planning to test this week. Were they able to resolve the issue, or is further assistance needed?- v-aatheeque
Hi dpatrick1
Just checking in again regarding the solutions we discussed earlier. Were you able to test them out, and did they help resolve the issue?
Please let us know the current status so we can determine if any further assistance is needed.
- mh2587
Super User
Change data type to Number or whole
When I do that it then sums all the WO numbers as a total value.
- v-aatheeque
Hi dpatrick1
I understand that you're trying to display a list of Work Order numbers in your matrix without them being summed or showing only the first or last number. Here’s how you can achieve that:
- First, make sure that the Work Order column is set to a text data type. This will prevent Power BI from attempting to aggregate the values.
- If you still want to use a Matrix and avoid aggregation, you can create a measure that returns the Work Order number as a string.
WorkOrderDisplay = CONCATENATEX(VALUES('YourTable'[WorkOrder]), 'YourTable'[WorkOrder], ", ")- Replace YourTable and WorkOrderNumber with your actual table and column names.
- This measure will concatenate all unique Work Order numbers into a single string, separated by commas.
To show each WO as its own row, put the Work Order field in Rows (not Values).
To show all WOs in one cell, write a DAX measure with CONCATENATEX and use that measure in Values.
Hope this helps !!
- v-aatheeque
Hi dpatrick1
Just following up on your question regarding displaying Work Order numbers in a matrix without summarization.
As shared earlier, if you’d like to see all Work Orders in a single cell, using a measure.
If you prefer to show each Work Order as a separate row, just drag the field into the Rows section of the matrix instead of Values.
Let me know if you had a chance to try this or if you’re seeing any issues I’d be happy to help you further !
- v-aatheeque
Hi dpatrick1
Just following up on your query regarding displaying Work Order numbers in a Matrix visual in Power BI without aggregation. We shared a solution using the CONCATENATEX function to list all unique Work Orders as a string, and also guidance on placing the field in the Rows area if you prefer individual entries.
Please let us know if the solution worked for your scenario or if you need further assistance.
We’re happy to help!
Looking forward to your response.
