Data Viz Done Right

January 31, 2018

Workout Wednesday: Dynamic Quarter Highlighting

2 comments
For week 5, I sent Luke and Rody a little challenge to see if they thought it was worthy of a WW. It all started with a question from a customer on Convo, which led me to creating this view, which led to it showing up on WW.

The requirements are simple:

  1. Allow the user to pick a starting month.
  2. Allow the user to filter the years.
  3. Based on the starting month, group the next 6 months into two quarters.
  4. Display the remaining months as individual months.
  5. Color the Quarters separately from the months.
  6. You can used table calcs or LODs.
  7. The quarters must appear in the correct order within the months based on each quarter's starting month.

Here's my solution. Enjoy the challenge!

2 comments :

  1. Replies
    1. That kind of defeats the purpose of the exercise. Keep at it. Think about the logic.

      Delete