Workout Wednesday 2024 Week 51 | Power BI: Highlight Data with a Slicer by Valerie Junk

shannonrlindsay — Wed, 18 Dec 2024 03:37:03 GMT

This week, we’re shining a spotlight on an incredible solution shared by community member Valerie Junk. It’s always inspiring to see how ideas ripple through the community—Valerie’s post was sparked by none other than Nikola Ilic, a powerhouse of creativity and insight in our space. I’m continuing my theme of community gratitude, celebrating the way we all learn and grow from each other’s work.

Let’s dive into this week’s challenge and explore Valerie’s brilliant approach! Join us to recreate Valerie’s solution where she uses a slicer to highlight (rather than filter) a visual! If you’d like to read up on the why behind the solution, I encourage you to check out Valerie’s complete blog post on this topic!

Requirements

Open the starter file and explore Valerie’s data. This challenge is awesome and so simple – we’re using a single table, a helper table and two measures!
- Note that the numbered steps documented in Valerie’s starter file correlate directly with her original blog post.
Add a bar chart containing the Category and Profit fields
Add a slicer containing the Category field
- Disable the filter interaction (in the format pane)
Create a helper table that contains the same values as the original table
- Hint: Helper Table = VALUES(Data[Category])
Add an additional slicer using the Category field from your new table
Sync your slicers
Create a measure to count how many categories are chosen.
- This measure will be used to format your bar chart.
Create a second measure to assign a color when a value is selected (or deselected)
Format your bar chart using conditional formatting and your new measures
Hide the original slicer using the selection pane
Ensure that all visuals meet the minimum standards of having alt text, that the tab order in your report makes sense, and that your color choices meet the minimum contrast standards.

Solution

Download this week’s solution file and watch Valerie’s tutorial on her blog! You can also play around with her published Power BI file (above) that contains written steps – it’s awesome!

eyJrIjoiMjI4MGZhYTUtOTIzMy00MjhhLWFmOTEtM2ZiZTEwMDllZjFkIiwidCI6IjNkMTEzNGZjLTg0ODItNDM1OC04ZmEzLWJiMjBiYzVmNTAxYiIsImMiOjF9

Re: Workout Wednesday 2024 Week 51 | Power BI: Highlight Data with a Slicer by Valerie Junk

PorcuBI — Tue, 24 Dec 2024 17:13:10 GMT

Thanks for reposting this! This solution works wonders for many of my clients!

topic Workout Wednesday 2024 Week 51 | Power BI: Highlight Data with a Slicer by Valerie Junk in Data Stories Gallery

Workout Wednesday 2024 Week 51 | Power BI: Highlight Data with a Slicer by Valerie Junk

Requirements

Solution

Re: Workout Wednesday 2024 Week 51 | Power BI: Highlight Data with a Slicer by Valerie Junk