Forum Discussion
Column sums by text work order numbers
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!
Community SupportHi 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.
- v-aatheeque
Hi dpatrick1
Just following up on your earlier question about displaying all Work Order numbers in your matrix.As mentioned in the previous response, Power BI matrix visuals don’t natively concatenate text values across multiple rows. However, we shared a workaround using the CONCATENATEX DAX function to list all the WO within each group context.
If you've had a chance to try it out, let us know how it worked for you or if you're seeing any issues, feel free to share more details so we can assist further!
If we don’t hear back, we may close this thread in line with our community guidelines, but you’re always welcome to post a new query anytime.
Thank you for being part of the Microsoft Fabric Community!