Chart Alignment

Hi nish18_1990 ,

The misalignment in your Clustered Bar Chart is due to the Sales values being made negative while Quantity remains positive. Power BI plots them on opposite sides of the axis, but because they belong to different measures rather than a single shared axis grouped by attribute, they don’t align properly. To fix this, you need to restructure your data using Power Query. Load your dataset, then unpivot the Sales and Quantity Q2 columns so that both values exist under one column named Value with a new column called Attribute indicating whether it's Sales or Quantity.

In Power Query, after selecting the Sales and Quantity Q2 columns, right-click and choose “Unpivot Columns”. This results in a table with Sub Category, Attribute, and Value columns. Next, create a custom column to flip Sales to negative so both measures plot from the same baseline. Use this formula in a custom column:

= if [Attribute] = "Sales" then -[Value] else [Value]

Name the new column Plot Value. Close and apply the query. Then in your Clustered Bar Chart, use Sub Category as the Axis, Attribute as the Legend, and Plot Value as the Value. This will align both bars on the same line, with one extending to the left (Sales) and the other to the right (Quantity), fixing the visual misalignment without having to fake it by manually hardcoding negatives.

Best regards,

Hi nish18_1990 

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

Hi nish18_1990 

We have not received a response from you regarding the query and were following up to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you!

Hi nish18_1990 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.