Forum Discussion
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.
- Anonymous3 years ago
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 _ RongtieIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
-
4 Replies
- AnonymousNot 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:
-
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.
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 _ RongtieIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
-
- pabeader
Post Patron
This is what I see when I try to adjust the conditional formatting for the data label on a column chart.
- AnonymousNot applicable
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 _ RongtieIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- pabeader
Post Patron
Sorry. Thought I was very clear. DATA LABELS is where the problem is. Not Title. DATA LABELS.
-