2026 Week 43 | Power BI: Visualising Lottery Patterns

Data:

1. Obtain the data from the link above or source your own
2. Model the data as needed

Visualising the draws:

1. Calculate the total number of lotto balls
2. Group the balls into groups of 5 or 10
3. Import Deneb custom visual and add the associated fields into the field well
4. Create a chart that displays the total number of lotto balls by total games (e.g. for a lotto that has 30 numbered balls, display 30 grey circles along the x-axis by number of games along the y-axis)
5. Colour each lotto ball drawn in each game by the groups created in 2.
6. Concatenate another chart to the right displaying just the drawn balls in order of group (Supplementary or power balls are optional)
7. Concatenate another chart to the right that highlights balls that are sequential in number (e.g. 6 balls drawn as white circles with black outline, filled black only when sequential numbers are drawn. e.g. 1,6,7,20,32,38 would appear as ○●●○○○)

Optional Extra:

1. Create a chart showing the most frequent draw patterns (e.g. ball groups)
2. Create a chart showing the most frequently drawn numbers

Get Creative:

Create your own visuals and redesign this report page to tell a better data story.