Hi!
A few months ago, I had the opposite problem that had been solved up until recently, and I just wanted to make Microsoft aware of a new issue as it is now affecting both Desktop and Service.
Anecdotally, Custom Data Labels have been hit or miss since I started working with Power BI around early 2021. After working for a few months, I believe they're once again broken (as of January 2024).
I create custom data labels because default data labels are usually too abundant and/or I want to modify what the label shows. Here's the dax again for the measure that I'm using for my custom data label, which remains unchanged since the previous post:
DataLabel.Safety.TPIR =
var _TPIR = [Safety.TPIR.OverTime]
var _month = MAX(slicer_Dates[Month])
var _mod = 3
var _currMonthMod =
MOD(
MONTH(
MAX(slicer_ProjectInfo[date.Safety.Latest])
),
_mod
)
var _formattedTPIR =
IF(
_TPIR > [Graph.Max.Safety.TPIR],
">"& FORMAT([Graph.Max.Safety.TPIR], "#,##0.00"),
FORMAT(_TPIR, "#,##0.00")
)
return
IF(
ISBLANK(_TPIR) || MOD(_month, _mod) <> _currMonthMod,
BLANK(),
_formattedTPIR
)
I have been using 2 other custom data label measures for other graphs (all are line and stacked column charts) following the same model as above, and honestly, I'm at a complete loss as to what is going on with this feature.
- Sometimes I'm able to change the color of the label text, sometimes I'm not. Sometimes, I'm even able to change it to one color, but not to another.
- Sometimes the labels show what the Custom Label returns, sometimes it shows what the actual data value is.
- Sometimes completely rebuilding the graph fixes the issue, sometimes it doesn't.
- Sometimes the data label displays correctly on Service while displaying incorrectly on desktop. Sometimes its the other way around.
- Sometimes the data lables just don't show at all, sometimes they do!
All of these things can occur simultaneously throughout the dashboard on different visuals. I don't even know where to start asking for help because the issues are changing every time I reopen the file on my desktop or refresh the page on service.
This may have turned into more of a rant, but I'm truly curious if anyone else experiences one or more of these issues and if there's any known fix/indication that a fix is in the works.
Cheers!
Edit: I have tried all combinations of Value/Detail/Layout I can think of but the issues persist.
