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.
It looks like you had it there at one time. Put [Year] on the X axis and drag [Alamama] to the Y Axis. Because Power BI wants to AGGREGATE things on the Y axis, it will make you choose something like SUM or MIN or MAX or COUNT.
But since for any one [Year], you have only one value for [Alabama] the SUM of that one value will be THAT ONE VALUE, along with the MIN and MAX. Just don't use COUNT.