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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Nigel99
Frequent Visitor

How to align x axis label of 2 charts

I created 2 charts ( 1 is line chart and another one is line and stacked column chart) and would like to put them on top of each other. They are sharing same x axis label which is categorical variable. How would I manage to accomplish? The x axis label of line chart seem to be offset a bit.

1 ACCEPTED SOLUTION

Ok, then my previous answer was right, 
Different graph types have different proportions .....

Excel is much more flexible, you can modify almost every pixel of the graphs, but Power BI is unfortunately not there yet...

So check other options to reach the desired goal, 
back to the beginning of the discussion for boxplot, you can use error bars.

https://www.youtube.com/watch?v=u6JVQKj5ijU

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

View solution in original post

9 REPLIES 9
Nigel99
Frequent Visitor

Nigel99_0-1708825009643.png

I would replicate the doubt using excel charts. I am trying to stack the line chart (front) and bar chart (back) of same width and height on Power BI. The x axis label seem to be switched i.e. "John" of line chart is not align with "John" of bar chart. I was expecting to see they are overlapping on each other. 

Ok, then my previous answer was right, 
Different graph types have different proportions .....

Excel is much more flexible, you can modify almost every pixel of the graphs, but Power BI is unfortunately not there yet...

So check other options to reach the desired goal, 
back to the beginning of the discussion for boxplot, you can use error bars.

https://www.youtube.com/watch?v=u6JVQKj5ijU

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

Ritaf1983
Super User
Super User

Hi @Nigel99 
Can you show please  what are you trying to do?

My apology for not able to sharing due to confidentiality. That being said, I was trying to place one chart (with transparent background) on top of another. My intention is to achieve boxplot. 

1. Line chart - display all data point including outliers

2. Line chart and stacked column chart - display Q1, Q2, Q3 etc

 

Both charts are sharing same categorical variable on x-axis. Upon combining, one of chart x axis label seem to shift, making both xaxis label not align.

Hi @Nigel99 

Not sure I understood the description correctly, but I'll try to guess 🙂

If the intention is to arrange proportions in 2 different types of graphs (line chart and combo chart it is not the same graph )that will be 100% identical, regardless of the distance between bars/points on the graph, we do not have any customization options.

Regarding box plots, try to see if the attached video link can help:

https://www.youtube.com/watch?v=u6JVQKj5ijU

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

Not identical though. The label is the same; the top one is not aligning with the one beneath.

The label doesn't matter this is a "proportions" question...
Different graph types have different proportions .....

Ohh I see...Meaning to say, no customisation setting to sort this out.?

Maybe I still didn't understand what you were trying to do.

Are you trying to sort the axes in the same order, or is there a problem where the same point doesn't appear exactly below the other in the two graphs?
It is very difficult to talk about and assist with visual topics based on words alone... I recommend again preparing a small example of what you are trying to accomplish. This will make it much easier for those who are trying to help.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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