How to compress a line graph to show everything at one place without scrolling?

[adhumal2]

Hi All,

I am trying to create a condensed view of below line chart. Is it possible to compress this line chart to show all values at same time instead of scrolling to right side. I am OK with crowded markers in the line chart.

Image 1 - Current Output

Image 2 - Desired Output

[PhilipTreacy · Accepted solution]

@adhumal2 

Thanks for the data.

I took your example and created 6000 rows using the same 4 column format.

Plotting a line graph with Emp ID on the x-axis, and Ratio, LCL and UCL on the y-axis I get this

Is this what you are after?

Here's my PBIX file and the Excel file I used as source.

regards

Phil

[adhumal2]

@PhilipTreacy Thanks a lot for your help. It worked. 🙂

[PhilipTreacy]

@adhumal2 

Please supply some sample data.  It's really hard to understand what's going on just by looking at screenshots.

Regards

Phil

[PhilipTreacy]

Hi @adhumal2 

In that case are the values on your x-axis actually numbers/dates?  Or are they text? 

If text, that's why you are only getting the option to plot them as categorical data.

You need to change them to numbers/dates to get a continuous x-axis.

Regards

Phil

[adhumal2]

Hi @PhilipTreacy 

Here is a sample data of 15 employees with their Employee IDs. I want to plot Employee ID vs Ratio as shown in the graph and check who falls above UCL (Upper control line) and below LCL (Lower control line). Hope this makes it clear. In actuals file I have 5000+ employee IDs. The desired output expected is attached in the original question above (ignore the date axis there)

Emp ID    Ratio      UCL        LCL

1	161	125	75
2	139	125	75
3	168	125	75
4	229	125	75
5	70	125	75
6	130	125	75
7	286	125	75
8	243	125	75
9	128	125	75
10	262	125	75
11	68	125	75
12	255	125	75
13	116	125	75
14	252	125	75
15	228	125	75

[adhumal2]

Hi @PhilipTreacy 

You are right. Those are actually employee IDs. I changed them to 'whole numbers' but now getting this strange chart

[PhilipTreacy]

Hi @adhumal2 

You've got the x-axis set to Categorical.  Set it to Continuous.

regards

Phil

[adhumal2]

I dont see the 'type' option. Its 'values' directly.

[PhilipTreacy]

Hi @adhumal2 

It visual should show all data.  Where are you seeing a scroll bar?

regards

Phil

[adhumal2]

@PhilipTreacy  I have too many numbers on column X. In this image you can see scroll bar.