AwesomeFace drawing in Power BI

100%

AwesomeFace drawing in Power BI

✓ Published0🌍 Public

Last edited Jun 7, 2017

Created on Jun 7, 2017

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.

AI-generated description

Similar vizzes

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

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

72% match

Loading thumbnail…

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

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.

HHugoberry

71% match

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

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

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

64% match

Loading thumbnail…

Let's make a face with D3.js!

This example demonstrates how to create an animated smiley face with moving eyebrows using D3.js. The visualization uses SVG rendering within an HTML page, with D3’s selection methods to build and manipulate facial elements. It relies on `d3.scaleLinear` and `d3.scaleBand` to map data from a hardcoded array of telescope observations, drawing bars and axes, then repurposes the same SVG canvas for the face. The face itself is constructed from basic shapes, with eyebrows animated through D3 transitions, showing fundamental DOM manipulation and data-binding techniques.

Jjuanandressr97

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

64% match