Solved: Data Label conditional formatting missing

pabeader · ‎07-03-2023

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 · ‎07-05-2023

Hi @pabeader ,

To select the field and apply it:

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.
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.

View solution in original post

pabeader · ‎07-05-2023

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

Anonymous · ‎07-05-2023

Hi @pabeader ,

To select the field and apply it:

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.
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 · ‎07-14-2023

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

Anonymous · ‎07-04-2023

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:

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.
Next to the Title text, select Conditional formatting (fx).

The Title text - Title dialog box appears.