formatting

2022 Week 31 | Power BI: Connected Scatter with PlotlyJS

Introduction This week for Workout Wednesday we are getting familiar with the PlotlyJS visual by creating traces and annotations for a connected scatterplot.   Connected scatterplots are a cross between a scatterplot and a lineplot whereby two numeric variables are connected by a third ordered variable (often time).   The below graph created with the …

2022 Week 31 | Power BI: Connected Scatter with PlotlyJS Read More »

2022 Week 26 | Power BI: Polar Plots with Charticulator

Introduction June is Music Month and this week we are getting arty with Charticulator. In our previous Charticulator challenges, we designed with cartesian plots, spiral plots and tried our hand at nested charts. For this challenge we use a Polar Scaffold to visualise songs segments by time/duration.   This challenge presumes some Power Query experience. …

2022 Week 26 | Power BI: Polar Plots with Charticulator Read More »

2022 Week 12 | Power BI: Build a Slicer Panel

Introduction Welcome back to Workout Wednesday – we’re glad you’re here! This week, we’re continuing on with our project management theme. We’re tracking project progress using data generated from Microsoft Planner. Using Power BI with Planner (as opposed to using the inbuilt charts) enables us to both customize visuals and to view more than one plan at …

2022 Week 12 | Power BI: Build a Slicer Panel Read More »

2021 Week 47 | Power BI: Custom Line Chart Formatting

Introduction This week we are continuing our design theme by working through a custom formatting hack for line charts. Conditional formatting in Power BI can be tricky at times, especially when trying to format different chart types.  If you are familiar with conditionally formatting a line chart, you’ll know that in the Data Colors section …

2021 Week 47 | Power BI: Custom Line Chart Formatting Read More »

2021 Week 45 | Power BI: Create a Custom Navigation Experience

Introduction We hope that you had a lot of fun last week re-designing Spencer’s report! This week we’re also focusing on design and creating a custom navigation experience using bookmarks and buttons.  I am looking for a new place to live and stumbled upon the 2017 State of American Well-Being report. This PDF report details community well-being …

2021 Week 45 | Power BI: Create a Custom Navigation Experience Read More »

#WOW2021 W44: Can You Show the Top and Bottom Profit Performers for the Selected Time Period?

Introduction To round out my beginner #WOW2021 series and as a nod to the most wonderful time of the year (#TC…duh), I wanted to re-imagine a couple of blasts from the Tableau Conference past…so while no points for originality here, my hope is that the principles of these tricks of the trade will help reduce …

#WOW2021 W44: Can You Show the Top and Bottom Profit Performers for the Selected Time Period? Read More »