Create Power BI Card Visuals That Act As Slicers Using New Slicer Visual
Vložit
- čas přidán 5. 08. 2024
- 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:
• Backlog Dashboard Revamp
DAX Format Function
learn.microsoft.com/en-us/dax...
-----------------------------------------------------
🎓 Power BI Dashboard Training
-----------------------------------------------------
👉FREE Power BI Quick Start Course - Learn how to create your first dashboard in around 90 minutes!
effectivedashboards.com/power...
👉 Power BI Quick Start PLUS - Learn how to craft KPI management dashboards that help you, your boss, and your peers make better decisions!
effectivedashboards.com/power...
-------------------------
📁 Resources
-------------------------
👉Access to the source PBIX files for this CZcams video:
effectivedashboards.com/cours...
👉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).
effectivedashboards.com/data-...
Great tip! Found your channel today, great videos!
Hi, Thanks for this educative video; but I have a problem with the label value, it gives the same value to all the tiles, and works just as a label. How did you overcome that?
How did you center the words? It seem like you skipped that from 5:15 to 5:17
Thanks for the video. I have problem with the new slicer version in that when i select a value, i go to another tab (report), and head back, the slicer is empty again. When using the old slicer it remembered my last selection. Do you recognize that?
Hey! Did you found any solution to that? I couldn't find yet!
I have the feeling they resolved it in new version. @@VTRABR2