How to show q[1-4] for month quater in range bar chart in x-axis in ssrs

Question

I have created a range bar chart in ssrs. I want to show x-axis label in quater format i.e q1 for jan,q2 for apr,q3 for july,q4 for oct

Here is the screenshot. I need to change from Month Jan-Q1.

Answer 1

I know nothing about your dataset fields so I am guessing.

Try this expression in x-axis labels:

=Switch(
Fields!Month.Value="Jan","Q1",
Fields!Month.Value="Apr","Q2",
Fields!Month.Value="Jul","Q3",
Fields!Month.Value="Oct","Q4"
)

EDIT: Add expression to label x-axis in range chart.

1. Right click on Category Groups Collection (in my case Month)

2. In general tab go to label textbox and add the expression.

3. Input the expression I provided you. (In my case Month is the calendar number of year, you should use the above expression)

4. This is the preview.

Let me know if this was helpful.