How to combine multi columns into a single attribute so that it can be used to plot graphs etc

[Anonymous]

I want to calculate effort by week. And I want to have a attribute which will contain all the columns CW1, CW2, CW3 etc so that I can create bar charts etc and plot the dimensions WEEK (CW1, cw2 ETC) 

like week versus name something like that

[Pragati11]

Hi @Anonymous ,

Create a new cocatenated column (CONCATENATE dax function) in your dataset using CW1, CW2, CW3. This will end up in a single column having concatenated values for these 3 columns. Then you can use it on a chart.

Thanks,

Pragati

[Anonymous]

But I cant use this then for filters or list. I want the those columns as  list output. 

[dax]

Hi @Anonymous ,

I am not clear  about your requirement? Did you mean that you want to use Slicer list to filter "cw"? If so, I think you could to unpivot the table, then use  values (column name) to create a new table , create relationship between them, then it should work. 

In addition, if possible could you please inform me more detailed information(such as your expected output and your sample data)? Then I will help you more correctly.

Please do mask sensitive data before uploading.

Thanks for your understanding and support.
Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

What is CW1, CW2. How the exists in the table and what is the final output you want.

[Anonymous]

[Anonymous · Accepted solution]

If I understand your question correct, you wish to have a single column only showing CW1/CW2/CW3?

This can be achieved if you go to "Edit Queries", select the three columns and select "Unpivot" under the "Transform" tab.

[Anonymous]

No pivoting.

If the variable week is there it will have all the column names like cw1, cw2 etc in a list and can be used as a filter