Introduction
There are times where we want to compare categorical data with a total, perhaps an average. And sometimes we don’t want to see that total at the bottom of a table. So this week we are creating a bar chart that contains a “total average” bar. We want the bar chart sorted descending by amount, so the total is not simply placed at the bottom or top for reference.
Currently in the United States, there is a lot of talk about the price of eggs as a symbol of rising costs that are not accompanied by rising income. I wanted to know just how much the price of eggs has changed compared to other food items, so I retrieved the data from the U.S. Bureau of Labor and Statistics and USDA for us to visualize.
Requirements
- Add a “total average” row to the data that contains the average of the unadjusted_percent_change values in the original data set.
- Plot the items and associated percent increase in a bar chart. Sort the items by descending value of unadjusted_percent_change.
- Add data labels to the bar chart to show the exact percent change for each item.
- Use a different bar color for eggs to make it stand out. Also, use a different color for your total average to make it look distinct from the other items.
- Use a canvas background color or image related to eggs.
Dataset
Data for this challenge can be found on Data.World at https://data.world/mlongoria/pbiwow2025w5.
There is a single table in the dataset.
Note: Data.World requires you to create a free account to access the data. You may use the Data.World connector in Power BI or download the file to your local machine and connect to it there.
Share
After you finish your workout, share on social media using the hashtags #WOW2025 and #PowerBI.
On Bluesky, tag @mmarie.bsky.social, @shan-gsd.bsky.social, and @merrykerry.bsky.social.