Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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-Jul | 15299 |
1-Aug | 57179 |
1-Sep | 5329 |
1-Oct | 31133 |
1-Nov | 8554 |
1-Dec | 19762 |
1-Jan | 14867 |
1-Feb | 268516 |
1-Mar | 30034 |
1-Apr | 10320 |
1-May | 30401 |
1-Jun | 13986 |
1-Jul | 8912 |
1-Aug | 18028 |
1-Sep | 8542 |
1-Oct | 34571 |
1-Nov | 13591 |
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
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
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:
Here is the data behind the graph:
Month/Year Total # Detected and Blocked
1-Jul | 15299 |
1-Aug | 57179 |
1-Sep | 5329 |
1-Oct | 31133 |
1-Nov | 8554 |
1-Dec | 19762 |
1-Jan | 14867 |
1-Feb | 268516 |
1-Mar | 30034 |
1-Apr | 10320 |
1-May | 30401 |
1-Jun | 13986 |
1-Jul | 8912 |
1-Aug | 18028 |
1-Sep | 8542 |
1-Oct | 34571 |
1-Nov | 13591 |
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
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
120 | |
101 | |
71 | |
61 |