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

Power BI

Creating a Power BI What-If Scenario Analysis

Creating powerful “what-if” scenario analyses and visualizations using Power BI modeling parameters.

Categories Data and Analytics Tags Power BI Leave a comment

Using Cards To Filter In Power BI

How to use a combination of Cards and Bookmarks to filter other visualizations in Power BI.

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

Accessing REST APIs with Basic Auth and API Key in Power Query

How to handle REST API queries in Power Query and Power BI where both Basic Authentication and API Tokens are required.

Categories Security Tags Base64, Power BI, Power Query, REST API, Security 2 Comments

Handling Paginated REST API Results with Power Query

How to query a REST API using Power Query and process the paginated results when the number of pages is either known or unknown.

Categories Data and Analytics Tags JSON, Power BI, Power Query, REST API 6 Comments

Mapping Cities in Power BI

How to render map visualizations with complex and duplicated city names in Power BI using geographical hierarchies.

Categories Data and Analytics Tags Power BI Leave a comment

Mapping Continents and Countries in Power BI

How to render both basic map and filled map visualizations in Power BI using continent and country names.

Categories Data and Analytics Tags Power BI Leave a comment

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.

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

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.

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

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.

Categories Data and Analytics Tags Excel, Power BI Leave a comment
Older posts
Page1 Page2 Next →

Popular Posts

  • Combination Clustered and Stacked Column Chart in Excel
  • Create Self-Signed S/MIME Certificates
  • How to Use Unicode Characters in Power BI
  • Display Total Inside Power BI Donut Chart
  • Mapping Continents and Countries in Power BI

Latest Posts

  • Creating a Power BI What-If Scenario Analysis
  • Power Query to Access Excel Data from Current Workbook, Local File, or SharePoint
  • Manually Create a WordPress Database from the MySQL Client
  • 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

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.