Watch the video above to learn how to set up a visual with a dynamic date axis in Power BI! Your user will be able to show a visual from a Daily, Monthly, or Yearly granularity. Even cooler, they can select the “Dynamic” option which will display the proper granularity based on the selected date range! See the following gif for an example.
I hope you enjoyed learning this advanced trick! If you liked it, make sure to check out my Training courses here. All memberships grant you access to a live SQL Server database to practice Power BI!
Really useful and well explained. I will update my Calendar table and use this constantly
Thanks! Hope you get some good use out of it.
can you also weekly in the same scenario? could you please add the dax for the same?
Hey there! Amazing trick. How would you add the weekly option?
Hey, this has worked really well for me, I even swapped it so that it displays things by end of month which has been a desire of mine!
how would you add a weekly column and type view? I know there are no DAX functions for end of week, so i’ve seen somethings that use Weekend = ‘Calendar'[DT]-MOD(‘Calendar'[DT]-1,7)+5, but i’m not totally sure how that would work here.
Could you please show as how to add weekly in the same scenario?
Is there any way to customize this with Time duration also involved? Basically am seeking for slicers that will allow to select between Last 1 Hour (values by minute), Last 1 Day (values by hour), Last 1 Week (values by hour), Last 1 Month (values by date), Last 6 Months (values by date) and Last Year (values by month).
This is very useful!
Is it possible to add a weekly where the x-axis is the week number and not date?
Thanks Parker, I’m so glad I found your website. I’ve had requests to show Power BI reports by day, week, month, quarter, and year, and this is by far the best solution I’ve found. Once I get to a slow-down point I’ll check out your blog and training. I thought there should be a way to do this, thanks again!
I have listened to this video many times and I still do not understand how when selecting Dynamic that the Currency Type gets switched to Daily, Monthly, Yearly based on the number of days that are selected. Can you explain this?