How to Create a Chart Visual for ABC Analysis

Hi somnath6309 ,

You just need to select the combo chart on the build bar

Now you can setup the values has you need:

Or do you want to have additional details like each product and each ABC Class?

Hi somnath6309 

What you are asking for is simply a standard combo chart:
bars for NumOfProducts and a line for Margin, like in the picture:

However, it’s important to mention that this visual is not ideal for this type of comparison.

A line chart is designed to show trends over time.
In ABC classification there is no time axis – only categories (A/B/C).
Using a line here creates a false impression of a trend that doesn’t actually exist.

Using two different Y-axes makes the visual hard to interpret.
The bar scale and the line scale are unrelated, so the shapes visually “cut” through each other even though the measures have completely different ranges.
This adds unnecessary cognitive load for the user.

If the goal is to compare the behavior of two measures across ABC groups, a cleaner and more accurate approach is to place two separate charts, one above the other, inside a single frame.
This allows the user to:

understand each measure independently

compare categories clearly

avoid scale confusion

The second image demonstrates this structure very well:

In summary:
A combo chart will work technically, but if the goal is clear and effective data visualization, two aligned charts (one for Margin and one for NumOfProducts) will give a much better result.

The pbix is attached

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