Learn a simple technique that allows you to show and hide Power BI field parameter slicers, while also making them more intuitive to use.
In this video, you'll use bookmarks, images, and field parameters to set up buttons that allow you to toggle between showing and hiding Power BI field parameter slicers.
Field parameters allow you to dynamically switch or select multiple measures and/or categories displayed in a visual. This is a great feature but does come with a bit of a drawback. The slicers used to switch between the measures or categories are the exact same slicers that can be used for filtering. This can lead to confusion.
In this video, you'll learn how to reduce this confusion.
Step 1: Create field parameters and assign them to the column chart visual
Step 2: Create bookmarks. First with the field parameters hidden, then with the field parameters shown and assign the bookmarks to the show hide buttons.
Step 3: Use DAX and conditional formatting to create a dynamic title for the chart. This will update based on the Power BI measure and category selected in the field parameter slicers.
Simple!
----------------------------------
⏩ Video Navigation
----------------------------------
00:00 - What we will create in this video
00:40 - Overall approach to the solution
02:08 - Set up field parameters
04:00 - Add a field parameter to a visual
04:41 - Configure field parameter slicers
07:18 - Add bookmarks to show field parameters slicers
10:25 - Add bookmarks to hide field parameter slicers
11:50 - Add actions to images to show hide slicers
13:35 - Add tooltip to button images
14:11 - Dynamic title measure
16:00 - Assigning title measure to visual title
16:55 - Summary of what was covered
-----------------------------------------------------
🎓 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 really do help you, your boss, and your peers make better decisions!
effectivedashboards.com/power...
-------------------------
📁 Resources
-------------------------
👉Access to the source PBIX files for my KZitem videos:
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-...
Негізгі бет Show and hide Power BI Field Parameter slicers to reduce confusion and save space
No video
Пікірлер: 1