Create Power BI Card Visuals That Act As Slicers Using New Slicer Visual

Sdílet
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-...

Komentáře • 6

  • @VTRABR2
    @VTRABR2 Před 4 měsíci

    Great tip! Found your channel today, great videos!

  • @annaefeturhi3284
    @annaefeturhi3284 Před 6 měsíci

    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?

  • @JasminPeterson-Hassan
    @JasminPeterson-Hassan Před 2 měsíci

    How did you center the words? It seem like you skipped that from 5:15 to 5:17

  • @richarddodeman9460
    @richarddodeman9460 Před 6 měsíci

    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?

    • @VTRABR2
      @VTRABR2 Před 4 měsíci

      Hey! Did you found any solution to that? I couldn't find yet!

    • @rd7910
      @rd7910 Před 4 měsíci

      I have the feeling they resolved it in new version. @@VTRABR2