Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
How to make the dynamic data label? Showing millions, thousand in columns of the same graph...
Solved! Go to 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
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
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 )
)
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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
96 | |
80 | |
67 | |
62 |
User | Count |
---|---|
138 | |
107 | |
104 | |
82 | |
63 |