Excel Lookup Using Date Ranges and Multiple Criteria in Power Query
How to use Power Query to retrieve a value when the date from the first table exists between an effective date range in a second table.
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.
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.
Revisiting NES Classics Using Nintendo Switch Online Rewind Feature
The rewind feature brings new life to classic and impossibly difficult NES games on Nintendo Switch Online.
Creating Cascading Drop-down Lists in Excel
How to create cascading drop-down lists in Excel. Selecting an option in the parent cell filters the available options in the dependent child cell.