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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Loonette
New Member

Graphing Highly Skewed Data

Hello all! I am looking for some suggestions on how to make a graph of highly skewed data without the data at the lower end of the scale doesn't look almost non-existent.   Here is the data that I am dealing with:

 

 

Month/YearTotal # Detected and Blocked 

1-Jul15299
1-Aug57179
1-Sep5329
1-Oct31133
1-Nov8554
1-Dec19762
1-Jan14867
1-Feb268516
1-Mar30034
1-Apr10320
1-May30401
1-Jun13986
1-Jul8912
1-Aug18028
1-Sep8542
1-Oct34571
1-Nov13591

 

 

As you can see, February is a huge number and makes the rest of the months unreadable.  Is there a way that I can take the amount on the left axis and condense the numbers from 60,000 to 200,000?  

 

Any ideas will be great appreciated.

 

Thanks!

Lori

2 REPLIES 2
v-yulgu-msft
Employee
Employee

Hi @Loonette,

 

Unfortunately, it is not allowed to condense a certain range of values on Y-axis. The interval of values displayed on -Y-axis is always commensurate. You may need to submit this idea here

 

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Loonette
New Member

Hello,

 

I am hoping that I can get some suggestions/help with graphing skewed data.  I have a chart where the month of February is huge making the rest of the months unreadable:

Skewed Data.PNG

 

Here is the data behind the graph:

Month/Year                                                                          Total # Detected and Blocked 

1-Jul15299
1-Aug57179
1-Sep5329
1-Oct31133
1-Nov8554
1-Dec19762
1-Jan14867
1-Feb268516
1-Mar30034
1-Apr10320
1-May30401
1-Jun13986
1-Jul8912
1-Aug18028
1-Sep8542
1-Oct34571
1-Nov13591

 

Is there a way that I can condense the left axis so that the values between 60,000 and 200,000 are basically not visible, allowing the other values to not seem so miniscule?

 

Any help with be appreciated.

 

Thanks!

Lori

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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