Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hey guys.
How can I adjust the padding/distance between the markers and the series labels and/or Y-axis values?
Gone through the Visualization options and can't seem to find the correct one.
Thank you!
Solved! Go to Solution.
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.
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
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.
Hi Rita
Thanks for the reply. Unfortunately I can't see the option to change the type from categorical to continuous.
Is this due to how I have my data setup? I have the "Quarter" column sorted by the "Quarter #" one.
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.
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!
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.
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
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.
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
60 | |
60 | |
54 | |
38 | |
27 |
User | Count |
---|---|
86 | |
61 | |
45 | |
41 | |
39 |