2024 Week 16 | Power BI: Timeline on a Sine Wave with Core Visuals


In this week’s challenge, we are creating a timeline visual on a sine wave.

You can use your creativity to break out the timelines into series, through conditional formatting, offsetting separate shapes, or create different shapes using different trigonomic functions.

Alternatively, with small multiples.


  1. Obtain the data from Kaggle and/or Wikipedia
  2. Create a list of dates in Power Query or using a calculated table with GENERATESERIES() (hint: as there are large number of dates, filter to a subset, e.g. >0)
  3. These dates will form the X-Values of your line chart
  4. Calculate the sine of X, this will form your Y-Values (hint as there are many dates you may need to multiply X by a fraction)
  5. Calculate the sine of the star trek episode data points
  6. Plot these X, Y and episode points on to a line chart and format accordingly.




Supplement with https://en.wikipedia.org/wiki/Timeline_of_Star_Trek#Before_Common_Era


After you finish your workout, share on Twitter using the hashtags #WOW2024 and #PowerBI, and tag @MMarie, @shan_gsd, @KerryKolosko. Also make sure to fill out the Submission Tracker so that we can count you as a participant this week in order to track our participation throughout the year.


Scroll to Top