Forum Discussion

pabeader's avatar
pabeader
Icon for Post Patron rankPost Patron
3 years ago
Solved

Data Label conditional formatting missing

As of the latest version for both Desktop and Report Server, the conditional formatting Fx marker for the text of a Data Label is missing.  Existing formatting is still working but I can't modify it.  

 

Please tell me I'm just missing it somewhere.  I've looked under every possible option but I can't find it anywhere.

  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi pabeader ,

    To select the field and apply it:

    1. Go to the Visualizations pane. In the Format area, select the General tab, and then set Title to On to show the title options for the visual.

    2. Next to the Title text, select Conditional formatting (fx).

      The Title text - Title dialog box appears.

    There are a few limitations to the current implementation of expression-based titles for visuals:

    • Expression-based formatting isn’t currently supported on Python visuals, R visuals, or the Key Influencers visual.
    • The field you create for the title must be a string data type. Measures that return numbers or date/time (or any other data type) aren't currently supported.
    • Expression based titles aren't carried over when you pin a visual to a dashboard.
    • Conditional formatting can only use measures defined in the underlying model and can't use measures locally created in a report (dataset connection).

    Please refer to my pbix file.

    More details: Expression-based titles in Power BI Desktop - Power BI | Microsoft Learn

     

    If I have misunderstood your meaning, please provide more details.

     

    Best Regards
    Community Support Team _ Rongtie

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi pabeader ,

    Is that what you're talking about? My desktop version: 2.118.621.0 64-bit (June 2023)

     

    To select the field and apply it:

    1. Go to the Visualizations pane. In the Format area, select the General tab, and then set Title to On to show the title options for the visual.

    2. Next to the Title text, select Conditional formatting (fx).

      The Title text - Title dialog box appears.

    More details: Expression-based titles in Power BI Desktop - Power BI | Microsoft Learn

     

    If I have misunderstood your meaning, please provide more details.

     

    Best Regards
    Community Support Team _ Rongtie

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

  • This is what I see when I try to adjust the conditional formatting for the data label on a column chart.

     

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi pabeader ,

      To select the field and apply it:

      1. Go to the Visualizations pane. In the Format area, select the General tab, and then set Title to On to show the title options for the visual.

      2. Next to the Title text, select Conditional formatting (fx).

        The Title text - Title dialog box appears.

      There are a few limitations to the current implementation of expression-based titles for visuals:

      • Expression-based formatting isn’t currently supported on Python visuals, R visuals, or the Key Influencers visual.
      • The field you create for the title must be a string data type. Measures that return numbers or date/time (or any other data type) aren't currently supported.
      • Expression based titles aren't carried over when you pin a visual to a dashboard.
      • Conditional formatting can only use measures defined in the underlying model and can't use measures locally created in a report (dataset connection).

      Please refer to my pbix file.

      More details: Expression-based titles in Power BI Desktop - Power BI | Microsoft Learn

       

      If I have misunderstood your meaning, please provide more details.

       

      Best Regards
      Community Support Team _ Rongtie

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

      • pabeader's avatar
        pabeader
        Icon for Post Patron rankPost Patron

        Sorry.  Thought I was very clear.  DATA LABELS is where the problem is.  Not Title.  DATA LABELS.