Design PatternNative + ConfigurationRecommendedLive example

Pattern — Ranking & exceptions

Which categories perform best/worst?

Interactive example

Filter bar

Ranked bar

Exception table

Design pattern — a composition of native components, not a Power BI feature in itself.

Simulated behaviour on the shared fictional retail dataset. Native mechanism: No — Design Pattern.

Best for

Sorted horizontal bar → conditional emphasis → Table for exact detail

Avoid when

Do not apply mechanically when the user question or data structure differs.

Typical data

Relevant recovered tags: design pattern, pattern, ranking & exceptions

Usage

Sorted horizontal bar → conditional emphasis → Table for exact detail

Power BI limitation

Sort by the analytical measure, not alphabetically.