cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Nexter Frequent Visitor
Frequent Visitor

Data Label Number Format Only Shows One Type?

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!!!

 

Capture.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Data Label Number Format Only Shows One Type?

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



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




4 REPLIES 4
Super User
Super User

Re: Data Label Number Format Only Shows One Type?

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



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




Nexter Frequent Visitor
Frequent Visitor

Re: Data Label Number Format Only Shows One Type?

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 Frequent Visitor
Frequent Visitor

Re: Data Label Number Format Only Shows One Type?

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

 

Arghhh!

Super User
Super User

Re: Data Label Number Format Only Shows One Type?

Hi @Nexter,

 

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

 

Regards,

MFelix



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!