SMART AXIS Magic | Let Power BI Choose the OPTIMAL Period
Have you ever wished Power BI knew the optimal number of periods to show? It is possible with my Smart Axis Magic :) ! Here is how to improve UX by creating a smart date axis that automatically picks the optimal calendar period based on the timeframe. In this step-by-step explanation we dive deeper into field parameters, data modeling, and DAX.
Enjoy this video and subscribe to always stay updated on my favorite Power BI tricks :)
Download link: https://my.datatraining.io/course?courseid=howtopowerbifiles
*See improved solution in the download files, where you don't need the bridge table and can use a between date slicer
--------------------------------
📊 TRAININGS 📊
---------------------------------
New! Power BI Design 4 Weeks Transformation Program https://my.datatraining.io/pages/powerbidesigntransformation
Learning Path https://my.datatraining.io/subscriptions?id=power-bi-zero-to-hero
For Custom Trainings and Consulting email directly support@datatraining.io
---------------------------------
⏱️ TIMESTAMPS ⏱️
---------------------------------
00:00 Intro
01:43 Step 1 - Creating a field parameter with periods
03:23 Step 2 - Creating a helper table
07:17 Step 3 - Creating the relationships
09:14 Step 4 - Applying a TopN filter
10:14 Demo - smart date axis
10:55 Finishing touch - Dynamic title
13:40 End
---------------------------------
😍 JOIN 😍
----------------------------------
Subscribe: https://bit.ly/31MnQGO
Website: https://www.datatraining.io
Facebook: https://www.facebook.com/groups/howtopowerbi
LinkedIn: https://www.linkedin.com/company/datatraining-io
Insta: https://www.instagram.com/howtopowerbi/
Twitter: https://twitter.com/HowToPowerBI
---------------------------------
👇 CHECK THIS OUT! 👇
---------------------------------
💻 My gear https://a.co/69HEjRu
📚 Power BI books MUST READ! https://a.co/5q5k6Dv
💡 General books I recommend https://a.co/05I4W2L
🎶 Music for my videos https://www.epidemicsound.com/referral/8pjcbj
🚀 For growing on YouTube: https://www.tubebuddy.com/bas
🏄 Stuff I use daily https://a.co/4V5CUJN
* Above are affiliate links, which means at no additional cost to you, if you make a purchase using these links we will receive a small commission. It supports us and helps us to continue making more How to Power BI videos!
Thanks for being a part of this channel and all your support! 💪 🙏
#HowToPowerBI #PowerBI #DataTraining
#powerbidesktop #powerbitraining #powerbideveloper #DAX