Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hello all, we are trying to show/hide the Data Label using a column with the definition below:
Display custom label = IF(
MOD(financials[Month Number], 2) = 0
, " "
)
This [Display custom label] field is being assigned to the field of Custom label in the Data Label visual of a chart.
I created an MRE (Minimal Reproducible Example) using the sample dataset (financials) provided by PowerBI to reproduce this issue and below is the result.
At the right side, it works fine on my PowerBI Desktop - Version: 2.118.828.0 64-bit (June, 2023).
However, when we publish to PowerBI Service, it is not showing the Data Label (at the left).
We could not provide the value for the False condition due to some constraints, but that is an optional field, the PowerBI Service should work like the one in the PowerBI Desktop.
This is the MRE: https://filebin.net/aoot6la1vnl4quvl
Any workaround or solution for this?
Thanks.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Anonymous ,
This fix has been rolled out to service and will be in the future version of desktop.
As a workaround:
You may update the DAX expression so it returns the field you would like to display when the condition is false. This will address your issue.
For example:
, " "
, financials[Gross Sales]
Community Support Team_Caitlyn