Custom Data Labels not showing up on Service

[kkolady]

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 addition of the custom data label. Without the custom data label it shows up fine.

The error says - "Can't display the visual. See details". On clicking details - "Couldn't load the data for this visual".

Any ideas / guidance would be appreciated.

[kkolady]

It is a measure. Also to keep it simple, I just tried using the same measure in the custom label as the measure being displayed in the chart. It still breaks.

Also another datapoint is that the report was working fine and then over the holidays - around Christmas the displays were broken.

Thanks, Kris

[hvnter]

Are your data source credentials up to date on your dataset?

What happens when you try and edit in the service. If you put your measure in a card or table visual by itself, what happens?

[kkolady]

The data source updates are happening flawlessly - so I'm assuming my credentials are still working?

the same measure that I'm using in the custom data label is also on a separate card that is visible.

Kris K

[hvnter]

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

[kkolady]

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]

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

[kkolady]

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

[hvnter]

Is your custom label a calculated column or a measure? If it's a calculated column, you might need to refresh your dataset for it to calculate