Transform Your Power BI Reports with Conditional Slicers | Advanced Slicer Formatting Options
In this Power BI tutorial, I’ll walk you through how to create a conditional slicer.
Have you ever wondered if it’s possible to show a slicer only when a certain condition is met? For instance, selecting a value from the Product Categories to trigger a Product Subcategory slicer to appear?
Well, with Power BI’s custom slicer formatting, you can make that happen!
In this video, I’ll show how you can dynamically display a slicer based on category selections. We’ll use simple DAX formulas and conditional formatting to create this effect, making your reports more interactive and user-friendly.
Throughout the tutorial, I'll cover:
Setting up conditional formatting for slicers.
Using DAX formulas to control slicer visibility.
Styling the slicer’s title, values, buttons, and accents.
Tweaks to improve the user experience, like hiding unwanted hover effects and scroll bars.
By the end, you'll be able to create clean, dynamic slicers in Power BI to improve your reports’ usability.
Why does this matter? Conditional slicers can enhance the UI and make navigation smoother for users, giving your reports a professional touch.
This tutorial is ideal for Power BI beginners and experienced users alike. If you find this video helpful, don’t forget to hit the like and subscribe buttons to stay updated with all my Power BI content!
Got questions? Drop them in the comments, and I’ll respond as quickly as possible. Thanks for watching!
Roland
🎬 MORE VIDEOS:
Fully Automated Power BI Access Management Tool using Power Apps and Power Automate - Part I - • Fully Automated Power BI Access Management...
Power BI & Power Automate - How to automate reporting process -
• Power BI & Power Automate - How to automat...
Dynamic Row-level Security 🔐 - Based on Dimension Tables - • Dynamic Row-level Security 🔐 - Based on Di...
Chapters:
00:00 Topic Of The Day - Show/Hide Slicers Conditionally
00:26 Intro
00:34 BI-Lingual Analytics
00:54 What's Covered Today
01:27 Report Basics
02:00 Subcategory Slicer Visibility
02:30 Conditional Formatting Setup
03:48 Finishing Touches
04:42 Summary
05:04 What's Next?
05:35 Feedback? Comment?
05:46 End
▼▼▼▼▼▼▼▼▼
Make sure to hit the 👍 button and ❗❗ SUBSCRIBE ❗❗ to my channel.
If you have any questions, just let me know either in the comments down below 👇 or send us an e-mail 📩.
▲▲▲▲▲▲▲▲▲
🤝 HOW TO CONNECT 🤝
LinkedIn - / bilingualanalytics
Twitter - / bilanalytics
Subscribe - / @bilingualanalytics
ABOUT ME: https://bilingualanalytics.com.au/abo...
📍 – Sydney, Australia
📽 GEAR:
📷 – Sony ZV-E10
🎙 – AT2020
🔦 – Neewer 18” Ring Light, Elgato Key Light
🎧 – BOSE QC35
🖥 – Dell Curved 34"
💻 – Macbook Pro M3 Max
#PowerBI #DataVisualization #Slicer