Dynamically change X axis interval from day to month to year based on date range.

[jkmajcen]

Google Analytics has very user friendly feature where if you are looking a bar chart for instance with a date range selection of less than 2 months or so days then the bar chart will group the data by day. If viewing a date range of 2+ months worth of data then the bar chart automatically shows data grouped by month. If you date range was multiple years than you'd get data grouped by year automatically when that grouping made sense. Showing day level granularity over many years would not make sense.

Does this functionality exist in Power BI out of the box or is this something you have to roll yourself? If you must roll your own, whats the best way to do this?

Thanks.

[v-diye-msft]

Hi @jkmajcen 

If you've fixed the issue on your own please kindly share your solution. if the above posts help, please kindly mark it as a solution to help others find it more quickly.thanks!

[jkmajcen]

Thanks for the input and links everyone.

[amitchandak]

@jkmajcen , I agree with @parry2k .

Every tool has its own flavor. Please check these post on Date Hierarchy and Relative Date

https://5minutebi.com/2017/11/29/how-to-use-powerbi-date-hierarchy/

https://www.skylinetechnologies.com/Blog/Skyline-Blog/January_2018/power-bi-drillthrough-built-in-da...

https://docs.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range

https://community.powerbi.com/t5/Webinars-and-Video-Gallery/PowerBI-Time-Intelligence-Calendar-WTD-Y...

[parry2k]

@jkmajcen there is nothing like that in Power BI except if you are looking at date level and your x-axis is categorical, it will show points for months and in case of continuous it will show all the dates, that's pretty much it but it gives you the flexibility to drill up and down, like Year -> Quarter -> Month -> Week -> Date, and you can make the hierarchy whatever the way you want.

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!