Forum Discussion

elz's avatar
elz
Advocate II
9 years ago
Solved

Stacked column chart formatting question

Hi All,

 

I created a stacked column chart and want to change the data labels to not display decimal places.

the problem is that the decimal places format field can't be changed.

it's set to "auto", but there is no drop down list to change it.

shouldn't this field have a drop-down list?

 

i'm wondering if there is a work around on the format section for this.

 

currently, the number is display as 4184.23K. i want to display it as 4184K.

any help would be greatly appreciated.


Thank you
Tracy

Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi elz,

    Make sure you are using the latest version of Power BI Desktop(August version). In your scenario, you can change the Display units to Thousands and directly enter 0 in Decimal Places field under Data Labels, then your data label will be displayed as 4184K. There is an example for your reference.


    Besides, when you enter 2 in Decimal Places field, your data label will be displayed as 4184.23K.



    Thanks,
    Lydia Zhang

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi elz,

    Make sure you are using the latest version of Power BI Desktop(August version). In your scenario, you can change the Display units to Thousands and directly enter 0 in Decimal Places field under Data Labels, then your data label will be displayed as 4184K. There is an example for your reference.


    Besides, when you enter 2 in Decimal Places field, your data label will be displayed as 4184.23K.



    Thanks,
    Lydia Zhang

    • elz's avatar
      elz
      Advocate II
      9 years ago
      hi lydia,

      thank you for letting me know that the decimal places option is now working.

      tracy