Introduction Welcome to this week’s Workout Wednesday. This week, we are taking advantage of some new features in the February 2024 release of Power BI Desktop. We can now have bars overlap in a clustered column chart and hide the inner borders in a stacked column chart. This week, we’ll use those formatting options to …
2024 Week 9 | Power BI: Use Bar Overlap and Border Formatting Read More
Introduction How is it the end of February already? Time flies when you’re having fun. I’m going to apologise first, as I think this week is going to be tough, and with that in mind I’m going to supply extra hints and tips along the way. This will test your Table Calculation Skills and Order …
#WOW2024 | Week 9 | Can you create these KPI Cards? Read More
Introduction This week’s challenge we will be utilising visual calculations (this will require turning Visual Calculations on in Preview settings of February 2024 Desktop) and some additional new data label formatting options to create a pipeline funnel with out of the box visuals in Power BI. Visual calculations can be handy for visual specifiic calculations …
2024 Week 8 | Power BI: Build a Pipeline Funnel with Core Visuals Read More
Introduction In this workout, we received weather data from weather machine, where every hour degree are stored in a column, and degree for each area are represented as a row. To easily work on this data, we need to transpose the data from column to row. sample source data Requirements Create a dev org or use an …
Introduction A good data visualization strikes a balance between enough and too much information. For this week’s challenge, we will explore a couple of ways to customize tooltips. Customizing these can help provide users with meaningful information without overwhelming or crowding the visuals. I’m sure you’ll knock this one out of the park! Need access …
2024 Week 8 | Sigma: Can you customize this tooltip? Read More
Introduction While reviewing recent work I’ve done in preparation for this week’s challenge, I came across a tile map with individual area charts by state that we use to monitor subscriptions, and thought it would be a fun one. As I dug into it, I realized it was inspired by Luke’s challenge in 2020 Week …
#WOW2024 | Week 8 | Can you create an area chart tile map? Read More
Introduction Welcome to Week Seven! This week, you’re going to create a line graph that can change its date granularity. With a dynamic x-axis, this graph allows users to view trends at the level that makes sense for their current needs, without duplicating work. Also in this challenge, you’re going to learn how to show …
2024 Week 7 | Sigma: Can you recreate this Line Graph? Read More
Introduction It’s already week 7 of our #WorkoutWednesday challenges (whoa, time flies…). In this challenge, I’d like to explore one aspect of the column multi-selection interaction in CRM Analytics: sorting. When we select more than 1 grouping, can we maintain the sorting within the selected groups, regardless of the selection’s order? We’ll find out in …
Introduction This week’s challenge is a little different, we will be looking to make-over a report from the Australian Bureau of Statistics. This report contains a lot of information and data sources to download, so it is up to you as to how much or how little you want to do. The primary challenge, however, …
2024 Week 7 | Power BI: Report Re-design – Aussie trips to Indonesia Read More
Introduction This week’s challenge is inspired by something I’d seen at work, and I thought it would be quite fun to see if I could reproduce in Tableau and if so, share as a challenge 🙂 I could, so here it is… can you include & exclude options with a custom control? Click to open …
#WOW2024 | Week 7 | Can you include and exclude options with a custom control? Read More
