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

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
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors