Best way to display bar chart with large number differences

[Pbidave1]

Hello,

I'm new to Powerbi. The first visualization I'm trying to create is a metric chart. Number of phone calls, number of new opportunities, number of new appointments, etc.

As you can imagine, each of these metrics have a wildly different count. The issue is that the visualization doesn't look very nice since some values are nearly 0 and some are several hundred.

Is there a good way to "scale" this so that it looks more proportional?

Thank you for any tips!

[v-qiuyu-msft · Accepted solution]

Hi @Pbidave1,

In your scenario, you can use the combo charts ( Line and clustered column chart, Line and stacked column chart ) to visualize data. Please the values which are nearly 0 in column values, and which are hundred in line values. Set the line values to use the different Y-axis from the column values via Show secondary feature.

Best Regards,
Qiuyun Yu