Forum Discussion
Creating a shared axis from multiple columns
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?
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.
6 Replies
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.
