Expression-based formatting

Important

This content is archived and is not being updated. For the latest documentation, see Microsoft Dynamics 365 product documentation. For the latest release plans, see Dynamics 365 and Microsoft Power Platform release plans.

Note

These release notes describe functionality that may not have been released yet. To see when this functionality is planned to release, please review What’s new and planned for business intelligence. Delivery timelines and projected functionality may change or may not ship (see Microsoft policy).

Power BI provides a variety of formatting options for all its visuals, and this semester we’re adding more advanced controls for report authors to dynamically change formatting based on the data in their model. Analysts can define expressions that modify the color, style or visibility of all elements within their charts. For example, they might change the color of a datapoint when the amount exceeds a target:

Data colors using expression-based formatting

Or they might adjust the style of one line in a series to call attention to it:

Line styles using expression-based formatting

Formatting can be based on any DAX expression and is affected by the context of any filters in the report.

This feature addresses the following Power BI Ideas requests:

• Conditional formatting throughout

• Better conditional formatting tools

• Conditional formatting for text

• Dynamically specify data color using column e.g. #A66999

Tell us what you think

Help us improve Power BI by discussing ideas, providing suggestions, and giving feedback.

• Use the Power BI Ideas site to provide suggestions for improving the product.
• Use the feedback area (Feedback or Is this page helpful?) at the lower right of this page to provide suggestions for improving the content in release notes.