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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
CahabaData
Memorable Member
Memorable Member

issues with horizontal scrolling

7000 rows excel imported into desktop BI.

 

have a line graph with horizontal dates - lots of dates (about 3 per date so about 2500 date points)  - ~10 years of dates

 

sliding/scrolling left to right is very cumbersome. 

 

is there no continuous scroll? - - or ability to reverse the order??

 

it begins default at the left which is the oldest/least current date - - to get to current date is kind of a maddening scrolling experiences...the jump back of the scroller control is slow and only goes back about 2 inches sometimes doesn't jump back at all it seems.

www.CahabaData.com
1 ACCEPTED SOLUTION
AlexChen
Microsoft Employee
Microsoft Employee

Hi,

 

I hope that you can check your  requirement. Normally we don’t need to show all detailed message on a graph.

 

I advise you use a date hierarchy to show different level of data.

 

I assume you have a table like below with 7000 rows:

 

1.png

 

To avoid a long scrolling bar on axis, you can create hierarchy to group the data and you can drill down to child level data.

 

2.png

 

If you want to reverse the order, you can go to upper right of your visual to sort by another field.

 

3.png

 

This is the result :

 

4.png

 

Best Regards

Alex

 

 

View solution in original post

2 REPLIES 2
AlexChen
Microsoft Employee
Microsoft Employee

Hi,

 

I hope that you can check your  requirement. Normally we don’t need to show all detailed message on a graph.

 

I advise you use a date hierarchy to show different level of data.

 

I assume you have a table like below with 7000 rows:

 

1.png

 

To avoid a long scrolling bar on axis, you can create hierarchy to group the data and you can drill down to child level data.

 

2.png

 

If you want to reverse the order, you can go to upper right of your visual to sort by another field.

 

3.png

 

This is the result :

 

4.png

 

Best Regards

Alex

 

 

thnx ....just a minor quibble... and feature request....

 

you state that the display order can be reversed by selecting sort 'by another field'....   that's really not reversing the order of field that is the sort field ....  it just so happens in your example that there was a continuous low to high such that choosing another field worked....  but the ability to reverse sort and begin with the current year would be helpful.....  reverse sorting in general to all visuals

 

 

www.CahabaData.com

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors