Dashboard Archives - Page 5 of 5 - PK: An Excel Expert

Fully Automated Excel dashboard with multiple source files

April 12, 2020September 19, 2026 PKComments Off

This Excel dashboard combines data from multiple source workbooks and worksheets in a folder using Power Query. It presents the consolidated results in a dashboard and a tabular view, with

Power BI Dashboard

Beautiful Power BI Dashboard with Northwind Database

March 24, 2020October 10, 2026 PKComments Off

This Northwind Power BI dashboard uses the Northwind sample database through an OData feed. Its three pages cover overall sales, product and category stock, and employee results. The tutorial also

Power BI

AI Visuals in Power BI: Original Examples and Tutorial

March 15, 2020October 10, 2026 PKComments Off

This tutorial explores Power BI decomposition trees, key influencers, Q&A and contextual Analyze insights with the original sample report. These tools help examine a metric across categories, identify influential factors

Charts and Visualization

Sales Dashboard in Excel 2013 Power View: Legacy Example

December 30, 2019October 9, 2026 PKComments Off

This sales dashboard in Excel 2013 Power View is a legacy example: it shows how PK built an interactive report with cards, a pie chart, a bar chart, a line

Power BI

Dynamic Conditional Formatting in Power BI with One DAX Measure

December 26, 2019October 9, 2026 PKComments Off

Dynamic conditional formatting in Power BI lets one DAX measure decide the colour of your cards, titles, columns, markers and map bubbles, so the whole report turns green when sales