Drawing Homer Simpson in Power BI. DAX code for Y coordinates.

100%

Drawing Homer Simpson in Power BI. DAX code for Y coordinates.

✓ Published0🌍 Public

Last edited Jun 9, 2017

Created on Jun 9, 2017

This example shows how to draw Homer Simpson’s head in Power BI by computing Y coordinates from a parametric equation, with a DAX measure named `HomerY` that takes an index and a function number as inputs. The measure uses ten distinct Fourier-series-like trigonometric functions (`fn0` through `fn9`), each selected via a `SWITCH` statement based on the function number, and evaluates the chosen expression using `LASTNONBLANK`. The code relies on DAX’s built-in math functions (e.g., `SIN`) and iterator `LASTNONBLANK` to access row context. The data comes from a table named `Homer`, and the visualization renders points whose Y values follow this formula, producing the iconic silhouette.

AI-generated description

Similar vizzes

Loading thumbnail…

Drawing Homer Simpson in Power BI. DAX code for X coordinates

HomerX.dax demonstrates how to draw Homer Simpson by computing x-coordinates from a trigonometric parametric equation, with the DAX `SWITCH` function selecting among ten distinct formulas (`fn0` through `fn9`) based on an index column. The code uses `LASTNONBLANK` to retrieve the current row's index and parameter values, then evaluates a piecewise function of sines and cosines to produce the shape. Each `fn` expression defines a segment of the figure, and the `RETURN` statement maps the index to the corresponding formula. The result is a scatter plot or line chart in Power BI that traces Homer's outline as the parameter `t` varies.

HHugoberry

93% 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

90% match

Loading thumbnail…

Prerequisites for drawing Homer Simpson in Power BI. The Power Query code for the iterator table [ranges]

This example demonstrates how to generate the coordinate data required to draw Homer Simpson’s head and facial features in Power BI. The code builds an iterator table by stitching together multiple angular ranges, each paired with a category descriptor, using a custom `range` function that leverages `List.Accumulate` to produce evenly spaced steps. The Power Query snippet, written in M, defines a function that takes a category, step count, and start/end angles (expressed in multiples of pi) to create the necessary points. The final `#table` call combines these ranges into a single dataset, illustrating a programmatic approach to constructing parametric shapes for visualization.

HHugoberry

77% 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

71% match

Loading thumbnail…

Gist f7ddd40cd326e033f91e1a433eeed7b9

This example plots a parametric curve of Mickey Mouse’s head and ears using a Fourier-style sum of sine waves. The visualization shows the iconic silhouette generated from 100 points, each computed via two long trigonometric expressions for the x and y coordinates. The code uses Power Query’s `Table` and `List.Accumulate` to generate the point table, while the actual plotting relies on DAX table expressions that define the coordinate formulas. The rendering approach is implicit, with the curve drawn as a continuous line from the calculated points, and the source data is purely synthetic, created from the mathematical functions rather than external data.

HHugoberry

67% match

Loading thumbnail…

Gist 4d1f4b4dc3b5e7c1353bd9ae3059b33a

This example visualizes a parametric curve in the shape of a fish, plotted from 100 discrete points. The code computes the x and y coordinates using trigonometric functions—x as `2*(cos(t) - (sin(t)^2)/sqrt(2))` and y as `2*sin(t)*cos(t)`—over a range of t from 0 to 2π. The data is generated in Power Query M, with the `Fish.M` table using `List.Accumulate` to create the point indices, while the DAX measures `Fish.dax xt` and `yt` supply the coordinate formulas. The rendering relies on the table’s `#table` constructor, though the drawing itself is not shown in the gist, focusing instead on the data preparation and coordinate transformation.

HHugoberry

62% 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

62% match

Loading thumbnail…

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

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.

HHugoberry

59% match