ChartsNative + ConfigurationUse with cautionLive example
Line + clustered column
Combine clustered columns and a line to compare related measures.
Revenue vs budget by department
FreshBeveragesGroceryNon-foodHousehold
Simulated behaviour on the shared fictional retail dataset. Native mechanism: Yes.
Best for
Sales in columns with margin % or target as a line.
Avoid when
Unrelated measures or misleading dual axes.
Typical data
Shared axis/category, Column measure, Line measure
Usage
Sales in columns with margin % or target as a line.
Power BI limitation
Dual axes can create false visual relationships.