Blog
Power BI Slicer for Multi-Value Columns: Splitting Delimited Data for Better Filtering
Learn how to create a Power BI slicer that splits delimited data, allowing easy filtering of multi-value columns without selecting grouped entries manually.
Why I Continue Blogging
Reflecting on blogging for knowledge sharing and personal growth despite AI challenges and low traffic.
How to Manage Digital Photo Clutter: A Guide to Photo Deduplication
Learn how photo deduplication can help you manage digital clutter, save storage space, and organize your photo library with easy, effective methods.
Astro: Manage Draft and Published Post Statuses by Adding a Content Collection Schema Property
Learn to manage draft posts in Astro by adding a property to your schema, filtering drafts in production, and keeping them visible in development.
Astro: Add Related Posts to Blog Entries
Learn how to add a related posts property to your Astro content collection schema and display related posts links on your blog using custom components.
Create and Use Custom Date Tables in Power BI for Date Hierarchies
Create custom date tables in Power BI using Power Query for precise control over date hierarchies, calculations, and formatting in reports.
PowerShell and Batch Scripts to List Files in Folder and Subfolders, Handle Long Paths and Complex Filenames in Windows
Generate a file list from a folder and subfolders using batch and PowerShell scripts. Handle long paths, filenames, and Unicode support.
Power BI: Create a Filled Donut Chart with DAX and Card Visualizations
Create a filled Donut chart in Power BI using DAX measures and Card visuals to display key metrics in the center.
Power BI: Unicode Characters in Visualizations
Convert text values into colorful icons in Power BI using DAX measures and Unicode characters for Table and Card visualizations.
Power BI: Filter Using Card Visualizations and Bookmarks
Create filterable card visualizations in Power BI using bookmarks and transparent shapes to enhance interactivity and user experience.
Excel: Combination Clustered and Stacked Column Chart
Combine clustered and stacked columns in one Excel chart without changing the source data structure.
Astro: Adding Previous and Next Post Navigation Links to Blog
Astro component adding relative navigation links to the previous and next blog post entries in a collection.
Excel VBA: Automate E-mail Content Extraction from Outlook
Custom VBA automation to extract information from structured e-mails in Outlook into Excel worksheet using both text-based and HTML table-based methods.
Excel VBA: Retrieving Outlook Address Book Values
Custom Excel VBA function to retrieve field values from an Outlook address book entry. Searches both local contacts and Exchange address books.
Astro: Collection Pagination Using Rest Parameter Dynamic Route
Astro pagination capability using collections and dynamic routes with a rest parameter. Resolves type issues and generates post listings with page navigation.
Power Query: Access REST APIs Secured by Basic Auth and API Key
Querying REST APIs secured by both Basic Authentication and API tokens, using Power Query. Anonymous instead of Basic authentication is used for the data source.
Power Query: Handling Paginated REST API Data
Multiple solutions for querying paginated REST APIs with known or unknown page counts or entry counts, using Power Query.
Power BI Map Visualizations: Mapping Continents and Countries
Display continents and countries using Power BI map visualizations. Country-level mapping is challenging due to geopolitical issues and inconsistent naming.
Power BI Map Visualizations: Mapping Common City Names
Accurately map common, non-unique city names using Power BI map visualizations by setting the correct data category and including country and coordinate data.
Why I Switched from WordPress to Astro
Switching from WordPress to Astro delivers improved performance, flexibility, and scalability at a reduced cost and with lower maintenance overhead.