Forum Discussion

kkolady's avatar
kkolady
Regular Visitor
2 years ago

Custom Data Labels not showing up on Service

In my report, when I add a custom data label a Clustered Bar Chart visual - it is not displaying when published to service. It displays fine on Power BI Desktop. I've narrowed the issue down to the a...
Need Help
hvnter's avatar
hvnter
Resolver I
2 years ago

Have you tried erasing it in the service and adding it back?

kkolady's avatar
kkolady
Regular Visitor
2 years ago

I've uploaded the report to my personal workspace and seeing similar behavior. Works fine without the custom label, but the visual is broken w/custom label.

 

Kris K

  • hvnter's avatar
    hvnter
    Resolver I
    2 years ago

    Then there is something in the DAX of your custom label that is breaking it. Can you share your DAX?

    • kkolady's avatar
      kkolady
      Regular Visitor
      2 years ago

      The visual is based on the measure [NE Bookings] ... here is the DAX code for the measures:

      Bookings = CALCULATE( SUM(FACTORDERS[BOOKED_VALUE]), DateCalendar[IsBooked] = TRUE )
      NE Bookings = CALCULATE( [Bookings],
          KEEPFILTERS(FACTORDERS[ORDER_TYPE] = "CURRENT" || FACTORDERS[ORDER_TYPE] = "NEW" ))

      The DAX measure for the custom label which breaks it is:
      Data Label NE Bookings = FORMAT([NE Bookings], "#,##0,,.00M")

      Anything concerning?
       
      Kris K