Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
M_nwadibia
Resolver III
Resolver III

How display last 4 weeks in ssrs bar chart report

Hello,

I have this report in bar chart and the data is continously growing by month. I am required to display only last 4 weeks on the chart.

How can I achieve this? Below is a sample of my data. I want to show only the last 4 weeks on the chart

 

M_nwadibia_1-1668476273772.png

 

1 ACCEPTED SOLUTION
v-henryk-mstf
Community Support
Community Support

Hi @M_nwadibia ,

 

You can create bar chart visual in ssrs.


Refer to the following blog for detailed steps.

Create Bar Chart in SSRS Report Builder (tutorialgateway.org)


If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.


Best Regards,
Henry


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2

You can change the chart to display all categories.


Switch to report design view.
Right-click the vertical axis, then click Vertical Axis Properties.
Under Axis range and interval, in the Interval box, type 1.
Select OK.
Click Run to preview the report.

Regards,

Rachel Gomez

v-henryk-mstf
Community Support
Community Support

Hi @M_nwadibia ,

 

You can create bar chart visual in ssrs.


Refer to the following blog for detailed steps.

Create Bar Chart in SSRS Report Builder (tutorialgateway.org)


If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.


Best Regards,
Henry


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.