Moving a Pivot Table Column to End of Values, Not Rows

[Tracy2573]

I have a column in my Rows section, but I would like to move it to the end of my Values section. However, the data in it needs to be text not amounts and I can't figure out how to do this. I have tried dragging and replacing, etc. but it doesn't let me move it manually.

I have attached a picture of where it is and where I want to move it to.

 

[sandy666]

using Power Pivot (DAX)

Re: Concatenate all related text values

Hi You can use CONCATENATEX within CALCULATE to do this. Something like: Supplier/s = CALCULATE ( CONCATENATEX ( VALUES ( 'Table 2'[Supplier] ), 'Table 2'[Supplier], " ", 'Table 2'[Supplier] ) ) CALCULATE is required for context transition just the same...

community.powerbi.com