cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
CahabaData New Contributor
New Contributor

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

Accepted Solutions
AlexChen Member
Member

Re: issues with horizontal scrolling

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

 

 

2 REPLIES 2
AlexChen Member
Member

Re: issues with horizontal scrolling

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

 

 

CahabaData New Contributor
New Contributor

Re: issues with horizontal scrolling

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