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: