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 that have an expense amount, budget amount, or budget percent used amount within the selected range.
For example, I may want to look at projects with budgets over 500 and the budget percent used at over 50%. I would do that by adjusting the second and third slicer.
Requirements
1. Retrieve the data from Data.World.
2. Create a slicer for expense amount that allows selection of values from 0 to 2000.
3. Create a slicer for budget amount that allows selection of values from 0 to 2000.
4. Create a slicer for budget percent used that allows selection of values from 0 to 200%.
While you could use DAX to create the values for the slicers, I would encourage you to use Power Query. List.Generate() is a great function! Note: The slicers must contain all the values found in the data between the minimum and maximum value, but there is no requirement that you must have every possible value in the list.
5. Create a table that contains the Project Name, Total Expense amount, Budget amount, and % of Budget amount. Ensure that the table is filtered only to the year 2024.
6. Bonus: Add an SVG to show a horizontal lipstick chart comparison of expense vs budget. Hint.
Dataset
You can find this week’s data on Data.World at https://data.world/mlongoria/pbiwow2024w21.
There are 4 tables 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 Twitter or LinkedIn using the hashtags #WOW2024 and #PowerBI. If you share on Twitter, please tag @MMarie, @shan_gsd, @KerryKolosko. Also make sure to fill out the Submission Tracker so that we can count you as a participant this week in order to track our participation throughout the year.