🧐 Create A Latest Day Slicer in Power BI
In this tutorial, I'll show you how to create a default slicer selection for the latest day in Power BI using Field Parameters. This is perfect for daily invoicing summaries or reports on job statuses.
If you're tired of manually updating slicers or filters every time new data comes in, this video is for you! We'll explore a solution that keeps everything within Power BI Desktop, no need for Power BI Report Builder or complex DAX.
I'll guide you through the steps to automate the process of selecting the last day. We’ll create a Field Parameter that references a measure, ensuring your slicer always shows the latest date. This method is beginner-friendly and avoids the hassle of manual updates.
We’ll also cover some small limitations and alternative solutions. By the end, you'll have a dynamic, up-to-date report without needing advanced tricks.
Stay tuned for a neat Tabular Editor tip from Owen Auger to refine your slicer. And if you want more advanced time filters like last week or year-to-date, check the links in the description for additional tutorials.
Don't forget to like, subscribe, and hit the bell icon so you never miss a Power BI update! Drop your questions and comments below-I love hearing from you and will respond as quickly as I can.
Let's dive into Power BI and make your reports smarter!
Roland
🔗 LINKS:
Owen's Blog: owenaugerbi.com
Custom Date Column using Power Query - blog.crossjoin.co.uk/2016/05/...
Custom Date Period using DAX -
bielite.com/blog/custom-date-...
🎬 MORE VIDEOS:
Fully Automated Power BI Access Management Tool using Power Apps and Power Automate - Part I - • Fully Automated Power ...
Power BI & Power Automate - How to automate reporting process -
• Power BI & Power Autom...
Dynamic Row-level Security 🔐 - Based on Dimension Tables - • Dynamic Row-level Secu...
Chapters:
00:00 Topic Of The Day - Default Latest Day Slicer
00:36 Intro
00:45 BI-Lingual Analytics
01:04 Existing Solutions
01:28 Field Parameters Solution
01:52 Exploring the Problem
02:58 Manual Slicer/Filter Update
03:35 Measure and Field Parameter
04:48 Field Parameter DAX
05:20 DAX Clarification - What's Left
05:42 Slicer Issue
06:05 Solution 1 - Filter Panel
06:30 Solution 2 - Tabular Editor
07:22 Help from Owen
07:35 Summary
07:55 Limitation
08: 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: 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 #PowerQuery #ReportAutomation
6 авг 2024
