Value scaling on the line chart behaving weired

[pgnilesh]

Hello Experts,

The issue I am seeing here is with Line Chart Auto scaling. Expect your help here to understand if it’s a bug or some setting/config.

I am using Line chart. X axis has DateTime and Y Axis shows Value Scaling. There are around 27 Tags which value is shown in the graph.

Only for 1 tag, value is in the range of 0 to 35.5K that too it happened only for 1 day. However, for all other tags, values is in the range of -10 to 130. Now check the behavior below:

With only 1 Tag Selected, scaling is gone upto 40K

With 13 Tag Selected, still Y axis is showing max 40K.

The moment I select 14th Tag, Y axis scaling is changed to 80. What I expect here he the scaling should remain at 40K cause of all the tag values, max value is 40K.  But that’s not happening here.

Is this a bug or I am making some mistake while designing? Appreciate quick help.

Regards,

Nilesh

[Anonymous]

Hi @pgnilesh,

I don't think this is a bug, it obvious cause with your records.(from 0 to 20k+). When y axis is setting as thousand unit, a part of records who has smaller values cannot be displayed accurately.

Unfortunately, current power bi not support broken axis feature, maybe you can submit at ideas forum or vote similar requirement.

Regards,

Xiaoxin Sheng

[pgnilesh]

Thank you @Anonymous for your reply.

I agree there is no broken axis feature but why it works for 13 tags and from 14th tag the Y axis comes down to 100. Ideally, it should have scaled up to the highest value of all the tags the way it is working till 13th Tag. Why only from 14th tag, it is scaling down.

Thanks,

Nilesh

[Anonymous]

Hi @pgnilesh.

I think it may related to label density, maybe you can take a look at following link to modify density to display more labels:

Can't find Line chart density

Regards,

Xiaoxin Sheng