Blog
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.