Build a self-filtering Excel dashboard with FILTER, SORT, and structured table references, no PivotTable required
No refresh button, no PivotTable, just a dropdown and a formula that already knows your table changed.
Dashboards
// 5 postsTutorials, tips, and deep dives on Dashboards — every post from bianca.codes tagged Dashboards.
Dashboards posts
-
-
Format painter: copy a Power BI visual's formatting in one click
Power BI's format painter copies fonts, colours and borders across visuals in one click, except for one axis setting that quietly breaks chart comparisons.
-
Most Power BI dashboards are just decorated spreadsheets
Three slicers and a card don't turn a spreadsheet into a data model, and the columns you didn't build are exactly where it falls apart.
-
The dashboard I built that nobody opened
Three months of polish, a great demo, and a usage metrics report that told a very different story once the meeting was over.
-
Build a dynamic dashboard with XLOOKUP and one drop-down
One drop-down cell, four XLOOKUP formulas, and every number on the dashboard updates itself - no PivotTable, no slicer, no VBA in sight.