I'm tasked with taking a manual process from creating Excel charts and making it work with SSRS.
What I need to do is be able to group based on a month number and a status.
Here is a snippet of the data:
NumberOfCases Subrogation_Type_VL_Name Case_Status_VL_Name MonthNumber
4 MVA Closed 1
1 Tort Closed 1
6 Work Comp Closed 1
6 MVA Open 1
2 Tort Open 1
4 Work Comp Open 1
8 MVA Closed 2
3 Tort Closed 2
4 Work Comp Closed 2
7 MVA Open 2
1 Tort Open 2
6 Work Comp Open 2
Here's how it is supposed to look:
I cannot get the chart to group based on Case_Status_VL_Name and MonthNumber.
Is this possible with SSRS 2016?
EDIT
My main issue was having one axis not display all of the labels, which made me think my chart or data was being shown incorrectly..
If your labels aren't showing correctly, click on the chart and set the LabelInterval and Interval properties to 1 which fixed the problem