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
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 !
Community SupportHi 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!