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 stepbystep 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 file here https://datatraining.io/powerbihowto

*See improved solution in the download files, where you don't need the bridge table and can use a between date slicer


TRAININGS

Power BI Design 4 Weeks Transformation Program https://my.datatraining.io/pages/powe...

Power BI Essentials https://datatraining.io/powerbilearni...

Business User Training https://datatraining.io/powerbibusin...

For Custom Trainings and Consulting email directly [email protected]


⏱ 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

Join https://bit.ly/4b453bi
Subscribe https://bit.ly/31MnQGO​
Insta   / howtopowerbi  
LinkedIn   / basdohmen  
TikTok   / how.to.power.bi  
X   / howtopowerbi  
fb   / howtopowerbi  
Threads https://www.threads.net/@howtopowerbi
Newsletter https://datatraining.io/newsletter


CHECK THIS OUT!

My gear https://amzn.to/47F21Yc
Power BI books MUST READ! https://amzn.to/3tUfFcj
General books I recommend https://amzn.to/48YNo33
Music for my videos https://www.epidemicsound.com/referra...
For growing on YouTube: https://www.tubebuddy.com/bas
Stuff I use daily https://amzn.to/3HqfMQ2

* 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