Introduction This week, we are recreating a previous Tableau workout in Power BI in which we build a segmented bar chart that contains a bar for the total amount followed by a bar that shows a categorical breakdown of that amount. This challenge involves a bit of data transformation as well as some more advanced …
2024 Week 29 | Power BI: Remake of a Tableau Segmented Bar Chart Read More
Introduction Power BI reports have a theme that specifies the default colors, fonts, and visual styles. In Power BI Desktop, you can choose to use a built-in theme, start with a built-in theme and customize it, or create your own theme. In addition to the primary data colors, we can also define sentiment colors and divergent …
2024 Week 26 | Power BI: Reference Theme Sentiment Colors in DAX Read More
Introduction While you can’t directly populate a slicer with a measure, you can use a slicer to filter other visuals based upon measure amounts. That is what we are doing in this week’s challenge. In the report below, we have a budget analysis report. The report allows users to filter the projects table to projects …
2024 Week 21 | Power BI: Use Slicers to Filter a Visual Based Upon a Measure Read More
Introduction Continuing on last week’s infographic theme, we are recreating an infographic from Visual Capitalist this week, this time showing average lifespan for different mammals. We will be using a scatterplot visual of your choice this week. I made two demo versions, one using the Deneb custom visual and one using the Enhanced Scatterplot custom …
2024 Week 18 | Power BI: Visualize Mammal Lifespan with a Scatterplot and Background Image Read More
Introduction Since I watched the solar eclipse from Texas this week, we have a solar theme. We are visualizing the sunrise time each day in 2024 to date. I’m keeping it simple with the line chart core visual, but you can use whatever visual you would like. Requirements 1. Retrieve the data from Data.World. 2. …
2024 Week 15 | Power BI: Visualize sunrise times with a line chart Read More
Introduction This week’s challenge uses a custom visual to achieve some formatting that cannot currently (as of March 2024) be achieved using core visuals. First, we have a table that contains 2 columns and no headers. Next, we have some contact cards that contain both an image and text. The catch is that the number …
2024 Week 12 | Power BI: Contact Cards and Headerless Tables Read More
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 I keep seeing a particular visual shared by a Denver-area meteorologist on social media. It seems to be output from weathermodels.com. I thought it might be fun to make a modified version in Power BI, so that is our challenge this week. While we don’t have native overlapping columns, there is a native solution …
2024 Week 4 | Power BI: Recreate this weather visual with overlapping columns Read More
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 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
