How to combine clustered and stacked columns in one Excel chart without changing the source data structure.
How to combine data from multiple data tables using DAX to create a clustered column chart in Power BI.
How to display Unicode characters and change their color in Power BI visualizations.
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.
How to perform complex lookups in Excel using multiple criteria through either a formula based on the sumproduct function or an array formula.