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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
marckmanga
New Member

Line Chart - Adjust Padding

Hey guys. 

 

How can I adjust the padding/distance between the markers and the series labels and/or Y-axis values? 

marckmanga_0-1718914628175.png

 

Gone through the Visualization options and can't seem to find the correct one. 

 

Thank you!

1 ACCEPTED SOLUTION
Ritaf1983
Super User
Super User

Hi @marckmanga 

Unfortunately, we don't have the option to define the Y-axis/ data series padding settings.

But when you use an X-axis value of the type number/date, you can change the axis type from categorical to continuous. Then the location will be automatically adjusted.

Ritaf1983_0-1719056896877.png

Ritaf1983_1-1719056946001.png

It is also important to note that from the perspective of effective data visualization, it is preferable not to display both the Y-axis and the values ​​at the ends of the lines.

This is unnecessary pixels for the user to read - "noise"

I recommend considering choosing either:

1. Axis (+ continuous grid lines instead of dotted lines for support) - in my opinion, preferable

Or

2. Only labels, no Y-axis

Ritaf1983_2-1719057435542.png

The pbix with the examples is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

View solution in original post

4 REPLIES 4
marckmanga
New Member

Hi Rita

 

Thanks for the reply. Unfortunately I can't see the option to change the type from categorical to continuous. 

 

marckmanga_0-1719076544077.png

 

Is this due to how I have my data setup? I have the "Quarter" column sorted by the "Quarter #" one. 

 

marckmanga_1-1719076762653.png

 

I looked it up and saw that values like texts cannot be distributed over a continuous axis - so it will be automatically interpreted as Categorical. But Im unable to change the type of the "Quarter" column. 

 

How did you achieve this with your screenshots that have 1st and 2nd Quarters as well? 

Hi @marckmanga 
As I mentioned the data type should be a whole number.
My quarters are 1&2 not 1st & 2nd...
You can see all my modifications and settings in the file that I attached with the first response.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

 

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

Ah shoot. My brain completely went over your "But when you use an X-axis value of the type number/date..." part. 

 

Just made the change and it works! Thanks for the uber quick reply!

Ritaf1983
Super User
Super User

Hi @marckmanga 

Unfortunately, we don't have the option to define the Y-axis/ data series padding settings.

But when you use an X-axis value of the type number/date, you can change the axis type from categorical to continuous. Then the location will be automatically adjusted.

Ritaf1983_0-1719056896877.png

Ritaf1983_1-1719056946001.png

It is also important to note that from the perspective of effective data visualization, it is preferable not to display both the Y-axis and the values ​​at the ends of the lines.

This is unnecessary pixels for the user to read - "noise"

I recommend considering choosing either:

1. Axis (+ continuous grid lines instead of dotted lines for support) - in my opinion, preferable

Or

2. Only labels, no Y-axis

Ritaf1983_2-1719057435542.png

The pbix with the examples is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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