Workout Wednesday 2026 Week 12 | Power BI: Custom matrix subtotals and cards with categories

Meagan — Sun, 29 Mar 2026 22:37:53 GMT

This week we are looking at some newer core visuals and formatting features: cards that in a segmented tile layout, a slicer that supports partial text matching, and a matrix where the percentage-of-total calculation changes meaning depending on whether you're looking at a subtotal or a detail row.

The bonus challenge pushes into SVG-in-DAX territory, using dynamic data bars and pill badges to visually distinguish country subtotals from product detail rows — all within a single matrix column.

For more info, see https://www.workout-wednesday.com/pbi-2026-w12/

eyJrIjoiYzBkNDMxOWItZDY2MC00NzlkLTgxNTAtZjIzODgyODc4M2Q0IiwidCI6Ijg3N2MzNGI5LWRjNDMtNGMwYS04N2MzLTgwZDcwN2FiYzY3MSIsImMiOjN9

topic Workout Wednesday 2026 Week 12 | Power BI: Custom matrix subtotals and cards with categories in Data Stories Gallery

Workout Wednesday 2026 Week 12 | Power BI: Custom matrix subtotals and cards with categories