Introduction It’s the last challenge of 2024! Whether you’ve been with us all year or are joining us for the first time, welcome! With the holiday season in full swing, we are keeping it light this week. We’re going to analyze some holiday movie data that I sourced from Kaggle. This dataset found movies on …
2024 Week 52 | Sigma: Can you analyze these Holiday Movies? Read More
Introduction Ever since I found out that Week 52’s challenge would be posted on December 25, I’ve been brainstorming ideas related to Christmas.While tackling Week 50’s Christmas tree challenge (as a personal challenge) and trying to solve it on a single sheet, I found myself wrestling with the concepts of “stems” and “leaves,” which reminded …
#WOW2024 | Week 52 | Can you create a Stem and Leaf Plots? Read More
Introduction Surprise! I have one more challenge for the year. This challenge was inspired by a workbook I created in my early Sigma days. We wanted to track weekly progression toward a quarterly total. Sounds easy, right? I thought so, too! But then I realized that DateTrunc(“week,” [Date]) would duplicate the week label across quarters. …
2024 Week 51 | Sigma : Can you calculate weekly progress? Read More
Introduction Welcome to Week 50! This week we’re playing with a new Sigma feature – modals! Modals are pop-ups that can contain any elements that you might otherwise have in another tab. There is so much opportunity with this feature, particularily when combined with actions! The formatting styles and colors in this challenge are all …
Introduction Welcome back to Workout Wednesday! This week, we’re shining a spotlight on an incredible solution shared by community member Valerie Junk. It’s always inspiring to see how ideas ripple through the community—Valerie’s post was sparked by none other than Nikola Ilic, a powerhouse of creativity and insight in our space. I’m continuing my theme of community gratitude, …
2024 Week 51 | Power BI: Highlight Data with a Slicer by Valerie Junk Read More
Introduction As we near the end of 2024, I have one last BIG challenge for you all. In the new year I plan to hit reset and get back to fundamentals. If you’re looking to take a break for the holidays, I hope you can come back to this head scratcher when you’re ready. This …
#WOW2024 | Week 51 | Filter for One Value OR All Others Read More
Introduction Welcome back to Workout Wednesday! This week we’re wishing everyone a very happy holiday season. Join us as we celebrate with a straightforward challenge, embedding a video in a Power BI report using the HTML Content custom visual. Requirements Create a custom image that you’ll use as your landing page. Create a custom video that you’d …
2024 Week 50 | Power BI: Happy Holidays! Embed a video in a Power BI report Read More
Introduction We’re going to try something a little different this week. We’re going to make a viz/dashboard without a dataset. Having just come from my daughter’s Christmas show this evening, and thinking I wanted to focus on container/dashboard formatting but keep it simple, I decided to build, then decorate a Christmas tree. So, that’s what …
Introduction This week, we’re diving into how to link a single color across multiple elements, giving users the power to choose which item gets the color splash. Plus, we’re checking out the latest tweaks to the Trellis options to make your visualizations even cooler. Have fun!-Katrina Need access to Sigma? Click Here to Sign Up …
2024 Week 49 | Sigma: Can you create a highlight action? Read More
Introduction A percentile is a number denoting the position of a data point within a numeric dataset by indicating the percentage of the data points with an equal or lesser (assuming it’s inclusive) value. Percentiles can be used to understand test scores, stock values, health indicators, and other values. This week, we will use them to look …
2024 Week 49 | Power BI: Visualize Ranges with Percentiles Read More
