Anonymous's avatar
Anonymous
Not applicable
3 years ago
Status:
Done

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.

 

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.

Dashboards
Reports

23 Comments

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi  Anonymous ,

     

    We have reported this issue and submitted it to the product team.
    They have been aware of the issue and the engineers will do their best to resolve it. I will update here if there is any progress, so please be patient. 

     

    Best regards.
    Community Support Team_ Caitlyn

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    hi Anonymous, noted, thank you.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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
  • R27878's avatar
    R27878
    Regular Visitor
    3 years ago

    Hi Anonymous 
    my problem is that

    in 

    SWITCH(TRUE(),...,...,...) combo
    no else or false part...
    what i do? 
    My automated reports do not look good... 
     
  • R27878's avatar
    R27878
    Regular Visitor
    3 years ago

    Hi Anonymous 

     

    I recreated the SWITCH(TRUE(),...,...,...) form to 
    IF IF IF form,  added Blank when the condition is false

    but the result is the same, not display Custom label in the visual.

     

  • Afives522's avatar
    Afives522
    Frequent Visitor
    3 years ago

    Hi,

     

    Has this been resolved? I'm still encontering the issue when I use custome label, it doesn't show in the PBI Workspace. 

    PBI Desktop: Version: 2.121.942.0 64-bit (September 2023)

  • migbenp's avatar
    migbenp
    Regular Visitor
    3 years ago

    Power BI Service do not show custom labels yet. Please help!!!

     

    Version: 2.121.903.0 64-bit (September 2023) 

     

    WEB View

    Desktop View

     

    I´ve tried simpler labels as well 😞

  • davejl's avatar
    davejl
    Regular Visitor
    3 years ago

    doesnt seem to work at my end as well..appears on pbi desktop but not online..

Completed Ideas