Category: Data and Analytics

Using Cards To Filter In Power BI

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

Simple SQL statements to clean unnecessary overhead, bloat, and orphaned data from WordPress databases without using a plugin.

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

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

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

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.

How to display the last modified date of the underlying source Excel data file used in a Power BI report.

How to create a custom date table and year, quarter, month hierarchy in Power BI using Power Query.

How to display a total and percent of total at the center of a Power BI donut chart.