Creating a shared axis from multiple columns

[mspiep01]

Hi all, pardon me if this is an awful question as I'm new to Power BI. 

I have multiple columns for various Impact variables. Each Impact can either have a Hiring Advantage or Hiriing Disadvantage for each record. 

I would like to creat a chart with the various Impacts across the bottom with count of Avantages and Disadvanatges to compare. 

A) Is there a way to do this? OR

B) Is there a better way to visualize?

[parry2k · Accepted solution]

@mspiep01 you need to unpivot your data to achieve this. 

- Go to query editor

- Select BRE ID column, right click on it, select unpivot other columns

- it will give you 3 column, BRE ID, Attribute, Value. Rename attribute column to Impact

- close and apply

Now you can use Value column on X Axis, Impact as Legend, Impact on Values which will be count.

[mspiep01]

After the 6th row it returns 'Error'

DataSource.Error: invalid query locator
Details:
List

Also, I left out the column for Meeting Date which would be a date we use to filter on.

[parry2k]

not sure why you leaving that out, how many columns you have?

[mspiep01]

I just left it out in my mockup.

I'm pulling a custom object from Salesforce. 

I have 13 columns in addition to ID

[parry2k]

I guess BRE ID is unique column, if yes, you cn create a duplicate column, remove all column from it, and keep these 4 column in duplicated table and unpivot that. 

Eventually you will have two tables, and then yu can set relation on BRE ID between those tables and that will get you going. 

[mspiep01]

@parry2k once I filtered out the null meeting dates it pulled the query with no problem.