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 works fine, the line chart and tooltip have the correct labels as you can see. However, on Service (2nd picture), the line chart continues working fine but the tooltip is ignoring the format and is showing values without the formatting.

 

Power BI Desktop: 

Power BI Service: 

 

The DAX measure is the following:

 

Thanks for any help!
Need Help

1 Reply

  • rajendraongole1's avatar
    rajendraongole1
    Super 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.