Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

0

Custom Label for Data Label not working on PowerBI Service

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.

CCLiew_0-1688552013123.png

 

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).

custom-label-not-showing.png

 

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.

Status: Delivered

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:

Display custom label = IF(
    MOD(financials[Month Number], 2) = 0

    , " "

, financials[Gross Sales]

)
 
Best regards.
Community Support Team_Caitlyn
Comments
Jitendrav
Frequent Visitor

Why this Isssue is came Repetative ?????


DHanken
Regular Visitor

EDIT: I was able to determine that the values 'toggle' in service needed to be manually changed; this appears to be fixed on my end for now! 

 

**********************************

 

This is still an issue as of yesterday/today for sure. Example of what I am struggling with below - any fix for this? 

 

Desktop:

DHanken_0-1703775340589.png

Online: 

DHanken_1-1703775379786.png

I am running on: DHanken_2-1703775403041.png

adamchurney
Regular Visitor

I've been having the same issues.   In Power BI desktop it showed the custom label, but when I published it in Power BI Service the custom data label reverted back to the default value.  Even after updating it in Power BI service and saving... it would revert back on the next load/refresh of the dashboard.   

 

I think i found a solution and testing so far it is looking good.  Inside Power BI service I turned off the data label all together, saved, and then turned the data label back on and then selected the custom label, and saved again and it seems to have retained the custom label even on reload and when other user launch the dashboard.