Combination Clustered and Stacked Column Chart in Excel
How to combine clustered and stacked columns in one Excel chart without changing the source data structure.
Data and Analytics
Combine Data From Multiple Tables to Create a Clustered Column Chart in Power BI
How to combine data from multiple data tables using DAX to create a clustered column chart in Power BI.
How to Use Unicode Characters in Power BI
How to display Unicode characters and change their color in Power BI visualizations.
Microsoft Power Query for Excel Tips and Tricks
Tips and tricks learned from using Microsoft Power Query for Excel including performance improvements, creating total rows and running totals, handling empty tables, and filtering using named range values.
Excel Lookup With Multiple Criteria Using SUMPRODUCT or Array Formula
How to perform complex lookups in Excel using multiple criteria through either a formula based on the sumproduct function or an array formula.