Trying to get multiple columns from a table onto the x axis

[Anonymous]

The data from our crm used to have the different criteria in a single column, making it easier to create a cluster column. However this has now changed so that the six options are now in columns when exported looking like this:

                       option a option b option c

Company 1       true       null         null

Company 2       null         true        null

Company  3       null          null      true

Any idea on how I can pull this into one column?

[Pragati11]

Hi @Anonymous ,

You can may be use concatenate to club all the column values into a single column or can directly merge all columns in POwer Query editor.

I like to go with the 2nd option as it is creating a column. You can do something like below:

Go to Power Query Editor in Power BI using Transform Data option.

Go and select your data-set there:

Select all the columns you merge together by using Ctrl+Click on windown machine and right click to choose Merge columns option:

Once you select Merge Columns  option, you get a window where you can choose separator and name for this merged column: (My selected options are shown)

Once yoou click Ok, both columns are merged:

 You can follow same steps in your scenario.

Thanks,

Pragati

[ryan_mayu · Accepted solution]

@Anonymous 

Is this what you want?

in PQ, select company column and unpivot other columns

[Anonymous]

Thanks, looks like it has worked. Would this be updated as the CRM is updated or will this have to be done manually?

[ryan_mayu]

@Anonymous 

if the raw data changed, these action steps will apply to the new data automatically.