Learn how to set-up the Power BI Button Slicer to look and feel like a card visual that also acts as a slicer!
There are often situations when you might want to display a row or column of card visuals that each show a filtered value within a category. For example, you might want to show 4 cards each displaying the number of backlog work orders for safety, environmental, production and routine work orders respectively.
In this situation, it also makes sense to be able to click on the card and filter the visuals on the dashboard by the category the card is showing filtering the values for. It just makes sense to be able to do this from a user experience and user interface point of view.
In this video, I'll explain how the new slicer visual can be set-up to mimic the look and feel of a simple card visual while also providing the functionality to click on the "cards" and filter the other dashboard visuals.
The key to this is a simple option that is offered by the new slicer button visual in Power BI. Check out the video to find out exactly how it's done.
----------------------------------
⏩ Video Navigation
----------------------------------
00:00 - Overview
01:00 - Adding the Button Slicer Visual
03.32 - Working with the layout of the slicer buttons
05.20 - Callout values and labels
06.48 - Formatting the numerical value displayed
08.32 - Changing the format of text on selected buttons
12:51 - Final tidy of card background and button borders
--------------------------------------------------------------------------------------
🎥 Related Videos / Resources
--------------------------------------------------------------------------------------
Maintenance Backlog Analysis Dashboard Revamp Playlist:
https://www.youtube.com/playlist?list=PLop0lNuba3nnaRyyfOYAOyxRlRhn__Slt
DAX Format Function
https://learn.microsoft.com/en-us/dax/format-function-dax
-----------------------------------------------------
🎓 Power BI Dashboard Training
-----------------------------------------------------
👉FREE Power BI Quick Start Course - Learn how to create your first dashboard in around 90 minutes!
https://effectivedashboards.com/power-bi-quick-start-create-a-pbi-dashboard-in-90-minutes/
👉 Power BI Quick Start PLUS - Learn how to craft KPI management dashboards that help you, your boss, and your peers make better decisions!
https://effectivedashboards.com/power-bi-quick-start-plus/
-------------------------
📁 Resources
-------------------------
👉Access to the source PBIX files for this YouTube video:
https://effectivedashboards.com/courses/free-resources/
👉Article series on creating a maintenance management system data model and how to address the human factors of data collection for improved data quality. (This is not just relevant to maintenance and reliability data).
https://effectivedashboards.com/data-articles/