Skip to content

John Dalesandro

  • Home
  • Blog
    • Technology
      • Automation
      • Cloud
      • Data and Analytics
      • Productivity
      • Programming
      • Security
    • Fun & Games
  • Laboratory
    • Analytical Spam Filter Plugin for WordPress
    • Micro Contact Form Plugin for WordPress
    • Head Trimmer Plugin for WordPress
    • Custom Field Embedder Plugin for WordPress
  • Site Information
    • About John Dalesandro
    • Contact
    • Privacy Statement

Data and Analytics

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.

Categories Data and Analytics Tags Excel 11 Comments

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.

Categories Data and Analytics Tags Excel, Power BI Leave a comment

How to Use Unicode Characters in Power BI

How to display Unicode characters and change their color in Power BI visualizations.

Categories Data and Analytics Tags Excel, Power BI Leave a comment

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.

Categories Data and Analytics Tags Excel, Power Query Leave a comment

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.

Categories Data and Analytics Tags Excel Leave a comment
Newer posts
← Previous Page1 Page2

Popular Posts

  • Combination Clustered and Stacked Column Chart in Excel
  • Display Total Inside Power BI Donut Chart
  • How to Use Unicode Characters in Power BI
  • Create Self-Signed S/MIME Certificates
  • Automate E-mail Information Extraction from Outlook into Excel Using VBA

Latest Posts

  • Upgrade PHP and PHP-FPM from the Command Line on a Debian LAMP Stack
  • Install a LAMP Stack Manually on a Debian OS Only Amazon Lightsail Instance
  • Automatically Back Up a Linux Server to Google Drive
  • Linting WordPress Code Using Composer and PHP_CodeSniffer
  • Using Cards To Filter In Power BI

Laboratory

  • Analytical Spam Filter Plugin for WordPress
  • Head Trimmer Plugin for WordPress
  • Micro Contact Form Plugin for WordPress
  • Custom Field Embedder Plugin for WordPress

Site Information

  • About John Dalesandro
  • Contact
  • Privacy Statement

Social

  • LinkedIn

Topics

  • Fun & Games
  • Technology
    • Automation
    • Cloud
    • Data and Analytics
    • Productivity
    • Programming
    • Security
Copyright © 2023 John Dalesandro. All Rights Reserved.