Exploring displaying microcharts and sparklines in table/matrix visual in PowerBI

100%

Exploring displaying microcharts and sparklines in table/matrix visual in PowerBI

✓ Published0🌍 Public

Last edited Mar 18, 2021

Created on Mar 18, 2021

This example demonstrates how to embed a wide range of microcharts and sparklines directly into Power BI table and matrix visuals using a single DAX measure. The measure returns a text string composed of Unicode block characters, which the visual renders as the final chart. The code includes a calculation table with pattern definitions for bar charts, bullet charts, win/loss charts, dot plots, candlestick charts, and horizontal comparison bars, each using characters like blocks, circles, and lines. The approach requires no external libraries, relying solely on DAX string manipulation and the native Unicode font rendering in the Power BI visual.

AI-generated description

Similar vizzes

Loading thumbnail…

PowerBI theme which uses Sparks font for sparkline rendering in matrix/pivot tables

This example demonstrates how a Power BI theme can repurpose the Sparks font family to render inline sparklines directly inside matrix and pivot table cells, replacing traditional numeric values with compact bar or dot visualizations. The theme defines three visual style variants—Default, Condensed, and Sparse—each applying a different Sparks typeface, such as "Sparks Bar" or "Sparks Dot Large Regular," to the table's values. It also adjusts row padding and background colors for alternating rows, while keeping column headers consistent. The configuration uses Power BI's JSON-based visualStyles schema, targeting the pivotTable visual and its values, grid, and columnHeaders properties.

HHugoberry

75% match

Loading thumbnail…

Gist ba3a80c35942582d77235e9fb4173416

This example shows a small, inline sparkline generated as a Scalable Vector Graphic (SVG) image URL from a Power BI measure. It plots a measure’s values over time for a single category, mapping each date to an X coordinate and each value to a Y coordinate within a 100×100 viewBox. The code uses DAX variables like `MINX`, `MAXX`, and `SUMMARIZE` to compute the normalized coordinates, then concatenates them into a `polyline` string. The result is rendered as a data URI with `data:image/svg+xml;utf8`, relying on the table’s `Date` and `Category` fields.

HHugoberry

72% match

Loading thumbnail…

KMeans clustering call in DAX Power BI desktop 3D

This example demonstrates a 3D KMeans clustering visualization built directly in DAX for Power BI, using the Iris dataset’s numeric columns (Column6, Column7, Column8). It shows how raw table columns are summarized and then passed into the custom `KMeansClustering` DAX function, which assigns each data point to a cluster and returns a cluster ID alongside the original attributes. The code explicitly constructs a DAX query with `SUMMARIZECOLUMNS` and `SELECTCOLUMNS` to shape the data, then calls `KMeansClustering` with parameter lists defining attribute roles and output columns. The rendering approach is not visible here, but the focus is on the algorithmic clustering step within Power BI’s DAX engine.

HHugoberry

66% match

Loading thumbnail…

Gist 599b117350a329c9046f68ae0ce1e21a

This example visualizes a k-means clustering result over a set of data points, showing how the algorithm partitions the space into distinct clusters based on two measured attributes. The chart is generated from a Power BI DAX query that first summarizes the source table `Query1` by summing the X and Y values for each category Z, then feeds those aggregated coordinates into the `KMeansClustering` function. The output assigns a `ClusterId` to each point, which the visualization likely encodes through color or position. The rendering relies on Power BI’s built-in visual engine rather than a custom JavaScript library, as no D3 or Canvas code appears in the provided DAX.

HHugoberry

65% match

Loading thumbnail…

AwesomeFace drawing in Power BI

This piece uses a trigonometric Fourier-series approximation to draw a cartoon smiley face in Power BI. The M query generates a table of 501 parameter values, while two DAX expressions compute x and y coordinates as sums of sine harmonics, each gated by sign-based window functions to segment the face into distinct arcs. The result is a procedural line-drawing rendered as a scatterplot, with the parametric equations encoded directly in DAX and Power Query.

HHugoberry

64% match

Loading thumbnail…

Power BI desktop tabular mining model

This example demonstrates a Power BI Desktop tabular mining model, exposing the structure of Data Mining Extensions (DMX) schema queries used to retrieve model metadata. The visualization shows how the model defines expressions, variations, sets, and extended properties, with the underlying code failing to access the referenced mining model due to permission errors. The implementation relies on Power BI’s tabular engine and DAX, while directly embedding DMX queries like `select* from $tmschema_expressions` to inspect the model’s internal schema. The rendering approach is native to Power BI’s table visual, displaying the raw query results and error states without external libraries such as D3 or Three.js, focusing instead on the interaction between DAX and the mining model’s metadata layer.

HHugoberry

64% match

Loading thumbnail…

Smooth line chart in Power BI

This example demonstrates a smooth line chart built in Power BI, where a dataset of ten numeric pairs is generated and plotted as a continuous, curved trend. The visualization highlights how Power BI can transform raw tabular data into an aesthetically refined line graph using a custom data-shaping query. The underlying implementation relies on a Power Query (M) script that constructs a table with columns `a` and `b`, populating `b` with random numbers via `List.Accumulate` and `Number.Random`. The chart’s smoothness comes from Power BI’s built-in line smoothing, applied to the rendered series. This approach shows how simple data generation combined with native charting capabilities can produce polished, interactive analytics.

HHugoberry

64% match

Loading thumbnail…

Drawing Homer Simpson in Power BI Scatter Chart

Homer Simpson emerges from a Power BI scatter chart as a single parametric function, computed by a DAX measure that maps data points across ten piecewise equations. The visualization uses LASTNONBLANK to select the current index and a trigonometric Fourier-series approximation to calculate X and Y coordinates, with the shape materializing through the intricate superposition of hundreds of sine terms. A categorical field switches between the ten function segments, and as users interact with the chart, the formulas dynamically generate the full character outline. The result is a remarkable proof-of-concept, transforming a dense block of mathematical expressions into a familiar cartoon face entirely within the constraints of a standard BI tool.

HHugoberry

63% match