Forum Discussion

Gian_Tafur's avatar
Gian_Tafur
Regular Visitor
2 years ago

Custom Data Label ignored in tooltip based on report page

Hi! I created a custom data label to format numbers in the visuals, but also have a custom tooltip based on report page where the visual also have custom data labels. On Desktop(1st picture), it wor...
Need Help
rajendraongole1's avatar
rajendraongole1
Icon for Super User rankSuper User
1 year ago

Hi Gian_Tafur  - This issue where custom formatting works in Power BI Desktop but not in Power BI Service is a common problem

 

slight modification of your dax:

Format_Acum_Opex =
VAR Value = [Acum_Opex]
RETURN
SWITCH(
TRUE(),
Value >= 1000000, Value / 1000000, // Convert to Millions
Value >= 1000, Value / 1000, // Convert to Thousands
Value <= -1000000, Value / 1000000, // Negative Millions
Value <= -1000, Value / 1000, // Negative Thousands
Value // Keep original for small numbers
)

 

Try re-publishing your report.Clear the browser cache & cookies.Refresh the dataset.

 

Hope this helps.