Menu
Stuff by Yuki
  • Home
  • Data Engineering
    • Python
  • Business Intelligence
    • Power BI
    • Tableau
  • Perspectives
  • About
  • Contact
Stuff by Yuki

How to Create a Waffle Chart in Power BI

Posted on January 6, 2023January 9, 2023

Waffle Chart in Power BI

An easy way to go about creating a waffle chart in Power BI is to use a custom visual. And that’s what I’ll be using to demonstrate in this blog. It looks like there is a way to do that without using a custom visual introduced in this data-goblin’s website .

Jsut FYI, I learned to use this custom visual because of one of the projects for Workout-Wednesday Power BI. It’s one of the best resources honing your Power BI skills that I recommend to anybody 🙂

Creating a Waffle Chart with a Custom Visual

I used this custom visual for the visualization. Please note that there is probably more custom visuals that can do that same.

  • Firstly, you need to download the custom visual from the marketplace in power bi deskop. Click on the three dots and once a window pops up, type in “waffle chart”. And pick the one on the left, created by kiewic.com.

  • Confirm that the visual has been added to your visualization collection. Note that I already pinned the visual, so yours will appear right below the three dots.

  • Then you click on the visual icon or drag and drop it onto the canvas just like you do when you create other visuals. And add fields that you want to see in the waffle chart.
I use “Segment” and a measure “% Sales Grand Total” I created on this dataset

Here’s the definition of my DAX measure:

Copy Copied Use a different Browser

% Sales Grand Total = 
VAR _Sales = [Total Sales]
VAR _AllInTheCurrentVisual =
CALCULATE (
    [Total Sales],
    ALLSELECTED ( Orders[Segment] )
)
VAR GrandTotalPercent = 
ROUND ( DIVIDE( _Sales, _AllInTheCurrentVisual ) * 100, 0 )

RETURN

GrandTotalPercent

That’s pretty much it! You can customize the figure used in the visual using this website. That’s done by changing “Paths” parameter in the visual.

But other than that, no further modifications are needed!

Here’s the final version of my visualization:

Power BI file you can download: my github repo

Conclusion

Hope you were able to follow my step by step instructions! This workout-wednesday project also teaches you to create the same visual.

1 thought on “How to Create a Waffle Chart in Power BI”

  1. whoiscall says:
    May 9, 2023 at 3:40 am

    Great post.

    Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Recent Posts

  • Where I’m Headed in the Next 5 Years
  • Open-Source vs Vendor Data Tools
  • Developing the Habit of Writing
  • How to Inspect and Optimize Query Plans in Python Polars
  • Learn Python Polars with Polars Cookbook

Popular Posts

  • A Running Total Calculation with Quick Measure in Power BI
  • A Complete Guide to Git Integration in Power BI
  • How To Copy And Paste Report Page in Power BI
  • Handling Missing Values in Polars
  • How to Convert String to Date or Datetime in Polars

connect with me

  • LinkedIn
  • Twitter
  • Github
  • Website

Search Articles

©2025 Stuff by Yuki | Powered by SuperbThemes