P01 - The Waffle chart
The versatility of the scatter chart now serving to display a waffle chart in Power BI but, with one DAX formula. Huge thanks to Mike Girvin aka "RAD Mike" for this marvelous formula logic for sequential numbering, it still do wonders when implemented in practical cases and it is the backbone of the DAX formula of this example.
Now, which one is more humane: 35 out of 100 or just a percentage: 35% ?
This was fun making in PowerBI with just one formula. Yes, just one DAX formula. Huge thanks to RAD master Mike "excelisfun" Girvin, his formula logic for sequential numbering which is the backbone of my DAX approach. Mike, as said a 1,000 times, that formula of yours still do wonders... thank you Maestro 🙏
Feel free to reach me via LinkedIn to get a copy of the pbix file
3 Replies
Carlos, this is awesome, very creative design and a great inspiration for further experiments. Obviously this can be converted to a single horizontal line with filled and empty blocks.
nyarlathotep - thanks! for the appreciation. Now, this: >> "....converted to a single horizontal line with filled and empty blocks." look its intriguing, you got any example about it?
carlosbarboza here is what i mean:
Some minor tweaks to the formating and layout are enough to get this; then, with different mark symbols, sizes, borders & transparency you can get some nice eye-candy for a progress bar 😉
In X-Axis I put `dt 01_waffle_pattern[Value]`, in Y-axis a measure that returns `1` & I kept the same conditional formatting -- that's all.
