## Yummy WAFFLE chart in Power BI

Waffles =
Power BI =

Waffle chart in Power BI =

So let’s make some waffle charts in Power BI. They can be a fun way to show single numbers in your dashboards.

## Waffle charts in Power BI – Step by step tutorial

### Step 0: Create the necessary measure to visualize

Let’s say you want to visualize a measure `[Preferred Value]` in the waffle chart.

### Step 1: Create a numbers table

To make waffles, we need flour, salt, baking powder and sugar. I am kidding, we won’t be baking any real ones here. We just need a disconnected table to make waffles.

Our table needs to have numbers 1 to 100, row & column values. You can either type one in Excel and bring it over or create one in Power Query. The final table shall look like this:

### Numbers table for waffle chart

Index has numbers 1 to 100, Row has 1 ten times, 2 ten times… and Col has numbers 1 to 10 repeated.

You can create this in Excel or Make it in Power Query too.

### Step 2: Add measure to harvest the number

Create a simple `[number]` measure with the formula `=SUM(Numbers[Index])`. This will simply return Index value when used in a visual with all row & col combinations.

### Step 3: Add measure to show Waffle Filled portion

Now that we have both [preferred value] and [number] measures, let’s create the final one. I call it [Waffle Filled].

`[Waffle Filled]:=IF([Preferred Value]<[Number],BLANK(),1)`

This measure simply returns 1 or BLANK() depending on the values.

### Step 4: Let’s make that waffle – Insert a Scatter Chart

Ok, we have prepped enough. The iron is hot, let’s whip up the waffle.

• Insert a scatter chart
• Add Numbers[Row] to Y axis
• Add Numbers[Col] to X axis
• Add [Waffle Filled] to size
• Click on X axis and choose “Do not summarize” option. Do the same for Y axis too.

### Our waffle chart at this stage

Not edible or comparable…

### Step 5: Format the waffle chart

Don’t freak out. This is not a radiation infested waffle. It just needs a bit of whacking around the edges.

• Fix the axis: Set axis limits from 0.5 to 10.5 for both vertical (Y) and horizontal (X) axis.
• Change the shape: Go to shapes format setting of the scatter chart and change the shape to square. Also set the size to -20 (try a few different values to see which works for you)
• Remove axis, axis labels, grid lines and anything else you don’t want.

Voila, our waffle is ready to eat.

## Watch the recipe for waffle charts in Power BI

If you burn your fingers while cooking these yummy waffles in Power BI, watch below tutorial video. You will learn,

• How to make the numbers table
• Creation of measures
• Waffle chart with scatter plot
• Waffle Table (2 dimensional waffles) with Matrix visual!!!