Power BI

2022 Week 48 | Power BI: Conditional SVG Measures

Introduction While we looked at SVG measures in a matrix in week 20, we are taking a different approach this week. SVG measures can be used in other visuals, and they can be designed to include links.   In the below Power BI report, I’ve got 4 visuals populated by SVG measures. Initially, all 4 visuals show …

2022 Week 48 | Power BI: Conditional SVG Measures Read More

2022 Week 47 | Power BI: WoW on Twitter

Introduction Welcome back to Workout Wednesday! This week we’re going to visualize Twitter data using Twitter’s API to retrieve tweets that have been made about Workout Wednesday! You have complete creative license to visualize the data in any way that you see fit. If you have a Power BI premium license, I encourage you to …

2022 Week 47 | Power BI: WoW on Twitter Read More

2022 Week 46 | Power BI: My Second Deneb

Introduction During week 42’s community month challenge brought to us by Thys van der Westhuizen – Thys built on my week 37 challenge – My First Deneb. For that week’s challenge I built out three basic bar charts using Deneb visuals, and subsequently, Thys continued to build a few more amazing visuals in his challenge. …

2022 Week 46 | Power BI: My Second Deneb Read More

How Brits met their partners

2022 Week 45 | Power BI: Ribbon Chart (Advanced)

Introduction Another Deneb visual this week – creating a custom Ribbon Chart.   This ribbon chart takes on a slightly different form than the ribbon charts you may be used to. This ribbon chart is focused on highlighting the change in rank and proportion of response types between the first and last dates of a …

2022 Week 45 | Power BI: Ribbon Chart (Advanced) Read More

2022 Week 44 | Power BI: Customer Lifetime Value

Introduction This week, our challenge is to calculate customer lifetime value by quarter using DAX.  This is an advanced challenge so buckle up! As I was working on my challenge for week 44, I stumbled upon the drafted challenge for Tableau on the same week.  The Tableau challenge was… you guessed it… developing a chart …

2022 Week 44 | Power BI: Customer Lifetime Value Read More

#WOW2022 W43: Advanced Formatting by Jeremy Anderson

Introduction Conditional formatting is a robust feature in Power BI that you can leverage to help users gain insights. Typically, we see conditional formatting applied to the table and matrix visuals. For example, you might apply a background color, font color, or icons to the values based on a set of rules.  Conditional formatting of …

#WOW2022 W43: Advanced Formatting by Jeremy Anderson Read More

2022 Week 42 | Power BI: Deneb Custom Visuals

Introduction I was recently asked by Rob Saunders if I would like to assist with a #WorkoutWednesday PowerBI challenge. To be seen in the same crowd with Kerry, Shannon, Meagan, Spencer, and Rob is such an honour. Cue the onset of imposter syndrome. After that feeling passed, Rob and I decided to continue with the …

2022 Week 42 | Power BI: Deneb Custom Visuals Read More

2022 Week 41 | Power BI: Likert Scale and Net Promoter Score (NPS)

Introduction This month we are getting the #WorkoutWednesday community involved in the challenges with Community Month. Each week we’re going to have an outstanding member of our community present a challenge. This week we have Gerard Duggan from sunny down under (Australia). Gerard rocks the Power BI community showing us how to present outstanding analysis …

2022 Week 41 | Power BI: Likert Scale and Net Promoter Score (NPS) Read More

#WOW2022 W40: Power BI: Field Parameters with Conditional Formatting

Introduction This month we are getting the #WorkoutWednesday community involved in the challenges with Community Month. Each week we’re going to have an outstanding member of our community present a challenge. This week we have one of the best out there, Sekou Tyler, gracing us with his presence. Sekou is an accomplished BI professional and …

#WOW2022 W40: Power BI: Field Parameters with Conditional Formatting Read More

Error Bars showing standard deviation from the average

2022 Week 39 | Power BI: Use error bars to show statistical ranges

Introduction We first looked at error bars in week 28. But error bars have several formatting features and can be used in several types of visuals. This week, we are going to use error bars to show a dynamically populated range around an average.  Requirements Calculate the average height and standard deviation for the heights. …

2022 Week 39 | Power BI: Use error bars to show statistical ranges Read More

Scroll to Top