Column sums by text work order numbers

[dpatrick1]

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

[dpatrick1 · Accepted solution]

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-aatheeque]

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.

[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.

[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!

[mh2587]

Change data type to Number or whole

[dpatrick1]

When I do that it then sums all the WO numbers as a total value.