Forum Discussion
How to make the dynamic data label?
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
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
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!!
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
