Restyle the data table as a "Clean Sortable Table":
- Card container: 1px border, 12px radius, overflow hidden.
- Header row: muted tinted background, 12px UPPERCASE letter-spaced labels, muted text; clicking a header sorts and shows a ▲/▼ indicator.
- Rows: 12px vertical padding, subtle zebra striping on even rows, accent-tinted hover.
- First column: bold item name with a muted secondary line (category). Numeric columns right-aligned with tabular numerals.
- No vertical gridlines; thin horizontal dividers only.
Keep all values, columns and sorting logic unchanged.
Convert the top-items table into a "Ranked Bar List":
- Each row: rank number (muted), item name + value on one line, and a full-width 8px rounded data bar beneath scaled to the max value (accent fill on a muted track).
- Right column shows a secondary metric (margin %); on hover, swap it to show units sold and highlight the row background.
- Generous 12px row padding, no table borders.
- In Tableau/Power BI: use a bar chart with labels on the left or a table with data bars conditional formatting.
Keep all values, columns and sorting logic unchanged.
Create a "Heatmap Metric Grid" of monthly sales:
- A responsive grid of tiles (6 per row desktop, 3 on mobile), each showing month label and value in $k.
- Tile background shaded on a single-hue sequential scale of the brand color (light = low, dark = high); switch text to the light foreground when the tile is dark.
- Clicking a tile highlights it with a ring and shows a detail strip below: sales, profit and margin for that month.
- In BI tools: highlight table / matrix with background color conditional formatting.
Keep all values, columns and sorting logic unchanged.
Category × quarter cells shaded by size or margin vs average
Prompt specifications
Tailwind / CSS
Add a "Heatmap / Conditional Formatting Matrix":
- Rows = categories, columns = quarters; cells separated by 4px gaps, 4px radius, centered tabular values.
- Toggle above: "Sales magnitude" (accent tint 10–90% by value) vs "Margin vs avg" (diverging: accent above average, red below, intensity by distance).
- Muted header labels; bold row labels on the left.
Keep all values, columns and sorting logic unchanged.
Tableau
Build a "Heatmap Matrix":
1. Power BI: Matrix visual with Category rows and Quarter columns; Conditional formatting → Background color → Gradient (min light, max accent). For margin use a diverging 3-color scale centered on the average.
2. Tableau: Highlight table (square marks) colored by measure; use a diverging palette for margin with center = AVG.
3. Add a parameter or bookmark to switch between Sales and Margin.
Restyle as a "Financial Ledger / Dense Accounting Table":
- Monospace 11px figures, tight 6px row padding, zebra striping on alternate rows.
- Currency columns right-aligned with 2 decimals and thousands separators so decimals line up; % columns right-aligned with 1 decimal.
- Bold "Total" subtotal row in the footer with a double rule above it (border-top double).
- Minimal header: muted labels, single rule below.
Keep all values, columns and sorting logic unchanged.
Tableau
Build a "Financial Ledger":
1. Power BI: Table visual, style preset "Alternating rows", font Consolas 9pt, totals on with bold and a top border; format currency to 2 decimals.
2. Tableau: Text table, banding on rows, Grand Totals on, number format Currency (2 dp), right-aligned.
3. Remove column gridlines; keep a strong line above totals.
Add an "Expandable / Parent-Child Hierarchy Table":
- Parent rows (categories) with a chevron that rotates 90° when expanded and a muted child count.
- Child rows indented 24px with a short tree connector line, muted text, values still right-aligned.
- Columns: Sales, Margin, Qty; header on a muted tinted band.
- Use aria-expanded on parent rows; first parent open by default.
Keep all values, columns and sorting logic unchanged.
Tableau
Build an "Expandable Hierarchy Table":
1. Power BI: Matrix with Category → Sub-Category rows, +/- row headers on, stepped layout on with indent ~20px.
2. Tableau: Hierarchy (Category ▸ Sub-Category) on rows in a text table; users click + to drill down.
3. Bold parent rows, regular child rows, right-aligned numbers.
Add a "Metric Progress & Sparkline Table":
- Columns: product (name + muted sub-line with sales and margin), 12-month micro sparkline (64×20, accent 1.6px line with an end dot), and goal progress.
- Goal progress: 80px 6px-tall bar on a muted track, accent when ≥100%, muted otherwise, plus the % label.
- Thin row dividers, no zebra.
Keep all values, columns and sorting logic unchanged.
Tableau
Build a "Sparkline & Progress Table":
1. Power BI: Table → add Sparklines on Sales by Month; add a progress measure (Current ÷ Goal) with Data bars conditional formatting.
2. Tableau: rows = Product, a small line chart column (Month on columns, hide axes) next to a bar for % of goal with a fixed axis 0–1.
3. Accent for hit goals, grey for not yet.
Restyle as a "Status & Badge Heavy Operational Table":
- Columns: order ID (mono) with date and value sub-line, customer with a 24px initials avatar, priority tag, status pill, and a "⋯" row action menu.
- Status pills: Delivered (secondary tint), In transit (accent tint), Processing (muted), Returned/Flagged (red).
- Priority tags small UPPERCASE; High/Critical in red tint.
- The action menu changes the row status instantly.
Keep all values, columns and sorting logic unchanged.
Tableau
Build an "Operational Status Table":
1. Power BI: Table with conditional formatting icons/background on Status and Priority; add a column of image URLs for avatars; use Power Automate or write-back buttons for actions.
2. Tableau: text table with shape marks for status; URL actions for "open order".
3. Status colours: delivered = secondary, in transit = accent, returned = red; always show the label too.
Add a "Rank & Delta Leaderboard Table":
- Each row: circular rank badge (top 3 filled accent, others muted), rank change with ▲/▼ arrow and places moved (accent up, red down, dash unchanged), product name, current value, and % change vs prior period.
- Compact 8px rows with dividers; caption explaining the comparison period.
Keep all values, columns and sorting logic unchanged.
Tableau
Build a "Rank & Delta Leaderboard":
1. Measures: Rank Curr = RANKX(ALL(Product),[Sales Curr]); Rank Prev likewise; Rank Δ = [Rank Prev] − [Rank Curr]; % Δ = DIVIDE([Sales Curr]−[Sales Prev],[Sales Prev]).
2. Tableau: RANK() table calcs on current and prior periods.
3. Table with icons (up/down arrows) on Rank Δ via conditional formatting; colour % Δ by sign.
4. Highlight the top 3 rows.