Power BI

Introduction In the December 2023 release of Power BI Desktop, some new formatting options were added for bar charts. These enhancements allow us to add borders around bars (and segments of bars for stacked bar charts), change the transparency of the fill color in a bar, and add secondary metrics to data labels.  With the …

2023 Week 52 | Power BI: Format Bar Charts with Transparency, Borders, and Detail Labels Read More

Introduction Happy holidays to everyone who celebrates! Join us this week to get some help shopping for your friends and family, using a dataset you provide and a random number generator in Power Query. If Clippy can’t pick a gift, no one can! Have fun and create the random gift generator in whatever way you …

2023 Week 50 | Power BI: Clippy’s Random Gift Generator Read More

Introduction The November 2023 release of Power BI Desktop includes the new button slicer visual. This visual can currently be used as a replacement for the original slicer visual when using tiles. There are more enhancements to come, but we already have a lot more control over the formatting of the slicer. We can add …

2023 Week 47 | Power BI: Use the New Button Slicer Read More

Introduction This week for Workout Wednesday we are performing RFM (recency, frequency and monetary value) analysis. RFM Analysis is a marketing technique used to quantitatively rank and group customers based on the recency, frequency and monetary total of their recent transactions. A score of 1 to 5 is assigned for each of the three main factors. …

2023 Week 46 | Power BI: RFM Analysis Read More

Introduction For this week’s challenge, we will be creating dynamic text boxes to introduce our visuals and tell a story around our data. This is differentiated from the “smart narrative” visual in that we will customize the text and measures that we display to create our own narrative. In the example below, you’ll notice that …

2023 Week 44 | Power BI: Dynamic Text Boxes Read More