Core Visuals, DAX, SVG & HTML

This is a collection of Power BI Core Visuals, DAX, SVGs and HTML for use in Power BI. All the work is original and where this has been inspired by the work of others, I have pointed this out.

Applied Filters (DAX & HTML)

Show users which filters have been applied with a high level summary and then show additional details on tooltip hover. This works with both slicers and when a user clicks a datapoint in a chart.

The high level summary shows how many columns and values have been filtered. If nothing is filtered, nothing is shown. The detail is shown when the user hovers over that summary. They will see a tooltip showing exactly which filters have been applied.

Supports the following config:

• Exclude entire tables
• Exclude specific columns
• Configure the max number of values shown before “…and x more” is shown
• Configure the max number of columns shown before “…and x more” is shown
• If your tables are prefixed with d for dimensions and f for facts, these can be removed automatically
• Format strings are automatically applied so your dates and currencies look correct
• Values are sorted correctly if a sort by column is specified

Full instructions in the .pbix.

Chips & Donuts (SVG & HTML)

A simple table that uses an SVG to show a donut as well as demonstrating the use of SVGs nested within HTML nested within SVGs for the display of the chips.

Chips (DAX UDF & SVG)

A UDF to easily create SVG Chips. Syntax is as simple as Bacci.SVG.Chip("Text","Blue")

Duration (DAX UDF)

A user-defined function that calculates the duration between two dates in the format n years n months n days.

Most existing algorithms I found rely on a simplified calendar (assuming 30 days per month and 365 days per year) and use basic MOD() and QUOTIENT() operations to determine the duration. This often produces inaccurate or unintuitive results. In contrast, this UDF calculates durations using actual month and year boundaries, resulting in a more natural, human-readable output. The results are displayed side by side for easy comparison with the conventional method.

Info Icon (HTML)

A HTML info icon which when hovered over, displays all the key details and context that readers need to understand the numbers they’re seeing.

Matrix Gradient (DAX)

Power BI conditional formatting for gradients is quite restrictive and limited to 3 colours. Using some simple DAX, we can easily interpolate between as many colours as required and have much more control over gradient boundaries.

Report Hub (HTML)

HTML Content (Lite) visual used to create a report hub. Use Direct Query to query the last refresh times from each semantic model.

Slicers (DAX & SVG)

Elevate the slicer user experience by showing how many records will be affected with each selection. Useful when using Sync Slicers functionality.

Tornado Chart (SVG)

SVG bars created using a User Defined Function. The bars can be left or right aligned and are used here to create a 2025 World Population Pyramid. Regular Power BI data bars cannot be used in this scenario as bar lengths cannot be uniformly scaled across multiple columns and would result in a misleading visualisation.

Source data: https://www.census.gov/