Forum Discussion
Y-axis problem and no problem with X-axis
Hi Anonymous, hello ToddChitt, thank you for your prompt reply!
Column Chart:
Designed for vertical comparison of values, so the Y-axis is typically used for numerical fields.
The X-axis is usually used for categorical fields, making it easy to compare values across different categories.
Bar Chart:
Designed for horizontal comparison of categories, so the Y-axis is typically used for categorical fields.
The X-axis is usually used for numerical fields, making it easy to compare values across different categories.
To address your issue, it's recommended to use a bar chart instead of a column chart:
Best regards,
Joyce
If this post helps, then please considerAccept it as the solution to help the other members find it more quickly.
Super UserWhat you show is a COLUMN chart (with vertical columns). For that, one would typically put the time series (years) on the X axis and that looks right. It shows the aggregation as MAX but you should be able to change that to SUM if needed. Is the data column [Alabama] numeric? Is it a measure
I'm not sure what the issue is.
Can you describe in spoken language what analysis you are wanting to display?
The data for each state is the average already calculated through excel before importing it into Power BI, I am wanting to display a simple graph showing the averages that is already calculated and does not need to be tampered with throughout the years 2000-2024. The x-axis displays the actual data but y-axis tampers it. When you say times series is typically put in x-axis, does that mean x-axis is for non-tampered data and y-axis is for data that will be tampered with?