Forum Discussion
X axis in bar chart
Okay.
So "Banking, Commercial, Education, etc" are separate columns.
Try the below steps;
1)Go to Transform Data.
2)Right click and select the columns which you want in your X axis.
3)Go to Transform from the upper tab and select 'Unpivot columns'.
4)You will get a 'Attribute' column.
5)Go to File ->Close and Apply.
6)On your report page, pick a visual and drag 'attribute' column on the Axis field and your calculation or measure on the 'Values' field.
If this post helps, then mark it as 'Accept as Solution'.
Regards,
Sanket Bhagwat.
can you share a screenshot of your expected output?
Anonymous ,
As you can see in the below screenshot, only one category is shown and the other categories are not.
Okay.
So "Banking, Commercial, Education, etc" are separate columns.
Try the below steps;
1)Go to Transform Data.
2)Right click and select the columns which you want in your X axis.
3)Go to Transform from the upper tab and select 'Unpivot columns'.
4)You will get a 'Attribute' column.
5)Go to File ->Close and Apply.
6)On your report page, pick a visual and drag 'attribute' column on the Axis field and your calculation or measure on the 'Values' field.
If this post helps, then mark it as 'Accept as Solution'.
Regards,
Sanket Bhagwat.