Forum Discussion
Regarding scroll bar in trend chart visual in Power BI
I need to have the scroll bar at the end of the trend chart by default. Is this possible to do in Power BI. If it is possible, Can you please let know the possible ways
Hi karthikaE,
If you mean the built-in Power BI line/trend chart scrollbar or zoom slider, then this is not currently possible as a native setting.
Power BI opens the visual from the start of the X-axis, and there is no option to set the default scroll/zoom position to the far right / latest date.
There are older community threads with the same question where the accepted answer is that the default scrollbar position can’t be changed:- https://community.fabric.microsoft.com/t5/Desktop/default-position-of-horizontal-scroll-bar/m-p/216855
- https://community.fabric.microsoft.com/t5/Desktop/Line-chart-scroll-aligned-right/m-p/928849
There is also a Fabric Ideas request for this exact behaviour, so you may want to vote/comment there:
Possible workarounds:
- Use a relative date filter, for example last 30 days or last 12 months, so the latest data is visible when the report opens.
- if your X-axis is a real Date/DateTime column, try setting the X-axis type to Continuous. In some cases this removes the horizontal scrollbar or makes the trend easier to read. Microsoft docs for X/Y-axis formatting are here: https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-customize-x-axis-and-y-axis
- Sort the X-axis descending, but this reverses the natural time order, so it may not be ideal for a trend chart.
Best regards,
Solutions Architect · Microsoft Fabric Specialist · Parchitect💡Did my response help you? Clicking Kudos is a small gesture that goes a long way, it encourages contributors and helps the community thrive!
✔️Did I answer your question? Please mark my post as a Solution, it helps others find the answer faster.
3 Replies
Hi karthikaE,
May I check if this issue has been resolved? If not, Please feel free to contact us if you have any further questions.
Thank youHi karthikaE,
If you mean the built-in Power BI line/trend chart scrollbar or zoom slider, then this is not currently possible as a native setting.
Power BI opens the visual from the start of the X-axis, and there is no option to set the default scroll/zoom position to the far right / latest date.
There are older community threads with the same question where the accepted answer is that the default scrollbar position can’t be changed:- https://community.fabric.microsoft.com/t5/Desktop/default-position-of-horizontal-scroll-bar/m-p/216855
- https://community.fabric.microsoft.com/t5/Desktop/Line-chart-scroll-aligned-right/m-p/928849
There is also a Fabric Ideas request for this exact behaviour, so you may want to vote/comment there:
Possible workarounds:
- Use a relative date filter, for example last 30 days or last 12 months, so the latest data is visible when the report opens.
- if your X-axis is a real Date/DateTime column, try setting the X-axis type to Continuous. In some cases this removes the horizontal scrollbar or makes the trend easier to read. Microsoft docs for X/Y-axis formatting are here: https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-customize-x-axis-and-y-axis
- Sort the X-axis descending, but this reverses the natural time order, so it may not be ideal for a trend chart.
Best regards,
Solutions Architect · Microsoft Fabric Specialist · Parchitect💡Did my response help you? Clicking Kudos is a small gesture that goes a long way, it encourages contributors and helps the community thrive!
✔️Did I answer your question? Please mark my post as a Solution, it helps others find the answer faster.Hi karthikaE,
Thank you for posting your query in the Microsoft Fabric Community Forum, and thanks to Parchitect for sharing valuable insights.
Could you please confirm if your query has been resolved by the provided solutions? This would be helpful for other members who may encounter similar issues.
Thank you for being part of the Microsoft Fabric Community.
