Data Label Number Format Only Shows One Type?

[Nexter]

Hi all,

I was wondering if someone could explain the logic in the below screenshot to me.  In Power BI, data labels seem to only have the ability to display one type of number format.  i.e. if there are numbers in the millions, and numbers in the thousands, data labels can only show either M or K, not both (even when set to auto).

I searched high and low for a fix/workaround, but to no avail.  This led me to belive that perhaps there is a reason behind this that I simply don't understand.  Can anyone let me know what the rationale might be behind this, or perhaps if there is no rationale but rather MS just hasn't provided a solution for this?  Thanks!!!

[MFelix · Accepted solution]

Hi @Nexter,

This is a question of readability, on the visuals. As a best practice the labels for the same data should be formatted in the same way otherwise the users will get issues in reading the data.

In Excel you can set point by point the data labels but in PBI this is formatted by group of data and  not single point.

Regards,

MFelix

[Nexter]

Thanks @MFelix

I can see how that makes sense. 

It's just frustrating though that you don't even have the option.  I see both choices as having their drawbacks; mixing the formats could potentially lead to a little confusion, but forcing my end users to think about what .14M and .07M translates to also adds a few seconds of extra comprehension (though obviously for most people those mental calculations will be instantaneous but still...).

[Nexter]

Also,  .07M doesn't give as much information as if it were to read 71.2K

Arghhh!

[MFelix]

Hi @Nexter,

Why don't you add more decimals to the value. you would get 0,712M not sure if it helps.

Regards,

MFelix