Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

0

Custom Label for Data Label not working on PowerBI Service

Submitted by Anonymous on ‎07-05-2023 03:28 AM

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
See more ideas labeled with:
23 Comments (23 New)
Comments
Jitendrav
Frequent Visitor
‎12-21-2023 11:48 PM

Why this Isssue is came Repetative ?????


DHanken
Regular Visitor
‎12-28-2023 06:57 AM

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
‎03-01-2024 07:26 AM

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.

Idea Statuses