How to make the dynamic data label?

[Amanda_Souza]

How to make the dynamic data label? Showing millions, thousand in columns of the same graph...

Example, I want it to show 16Mi and 28k, instead of 0Mi

[Anonymous]

Hi @Amanda_Souza ,

Whether your problem has been resolved? If yes, could you please mark the helpful post as Answered? It will help the others in the community find the solution easily if they face the same problem as yours. Thank you.

Best Regards

[Anonymous]

Hi @Amanda_Souza ,

Base on my research, there no option to customize set the format of label values base on the different value range. You can refer the following blog to create another measure to get the value with different format and apply this measure onto Tooltips option.

Power BI - Change display unit based on values in table - Power BI Docs

Custom Display unit =
Var TotalSale = SUM('Global-Superstore'[Sales])
Var decimals = "0.0"
RETURN
SWITCH ( TRUE() ,
TotalSale > 1000000 , FORMAT ( TotalSale / 1000000 , decimals & "M" ) ,
TotalSale > 100000, FORMAT ( TotalSale / 100000 , decimals & "L" ) ,
TotalSale > 1000 , FORMAT ( TotalSale / 1000 , decimals & "K" ) ,
FORMAT ( TotalSale , decimals )
)

Customize tooltips

Best Regards

[Amanda_Souza]

Hi, I did as you said but it only works in the table visual, when I switch to the column chart visual it keeps showing 0Mi... Could you try with using the column chart please?

Thanks a lot!!

[Anonymous · Accepted solution]

Hi @Amanda_Souza ,

Since you add the measure to the option Tooltips, it will only shows the value of this measure with custom format when you hover over a data point on the column chart(see the below screenshot). The value of the data label still keep the original ones...

Customize tooltips in Power BI

Best Regards

[daXtreme]

As far as I know, you can't do this natively since there's no conditional formatting on this item. Your only hope could be (but not necessarily will) Calculation Groups/Items. But this is rather advanced topic. You need to use an external tool for this: Tabular Editor.