Display Excel File Modified Date in Power BI
How to display the last modified date of the underlying source Excel data file used in a Power BI report.
Data and Analytics
Custom Power BI Date Tables Using Power Query
How to create a custom date table and year, quarter, month hierarchy in Power BI using Power Query.
Display Total Inside Power BI Donut Chart
How to display a total and percent of total at the center of a Power BI donut chart.
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.
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.