Answered by:

HOW TO ADD MORE THAN ONE CATEGORY FIELDS IN SSRS CHART

Question

trying to create an SSRS chart with multiple category fields on x-axis. when i drag and drop more than one column on the x-axis ,the 2nd column becomes the child of
the 1st column. i want each columns to be stand alone. sample expected chart below

Answers

Based on my test, we can use UNPIVOT function which performs the operation by rotating columns of a table-valued expression into column values to achieve your goal. For UNPIVOT function, you can see the link:
Using PIVOT and UNPIVOT. To resolve the issue, please follow the steps:

1. Create a dataset which type the similar commands below in Query Designer:

All replies

Based on my test, we can use UNPIVOT function which performs the operation by rotating columns of a table-valued expression into column values to achieve your goal. For UNPIVOT function, you can see the link:
Using PIVOT and UNPIVOT. To resolve the issue, please follow the steps:

1. Create a dataset which type the similar commands below in Query Designer: