High volume entry affecting chart scale, move to secondary axis or divide by 10,100

[Anonymous]

Hi guys, 

In below screenshot I have a value that is in the 100 where the rest are in 10s whats the best way of handling this?

[v-shex-msft]

Hi @Anonymous,

For your requirement, I think broken axis chart will be suitable, but current power bi not support this feature, I think you can send this requirement to ideas forum.

Reference:

Broken Y Axis in an Excel Chart

Regards,

Xiaoxin Sheng

[Anonymous]

Is it possible to sum the event types (activity) that are candidate calls and divide it by /10 or /100? 

[dkay84_PowerBI]

Generally if you have data that are orders of magnitude different scale, normalization via logarithm will help.  Not sure if this can be used in this use case, but thought I would point this out.

If you can get away with a line and column chart, you can set two different axes, but again, not sure if this is applicable here.

[Anonymous · Accepted solution]

I guess I could create a new table that is just the Candidate calls from the events table and then join to back to it so I can still use the ref as the count value? I'll give it a go. Thanks.