Skip to main content
cancel
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

Reply
pabeader
Post Patron
Post Patron

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.

1 ACCEPTED SOLUTION
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.

vrongtiepmsft_0-1688605794474.png

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.

View solution in original post

4 REPLIES 4
pabeader
Post Patron
Post Patron

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

 

pabeader_0-1688560925139.png

 

 

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.

vrongtiepmsft_0-1688605794474.png

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.

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

Anonymous
Not applicable

Hi @pabeader ,

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

 

vrongtiepmsft_0-1688522618268.png

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.

 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.