Set custom intervals on x axis

[Anonymous]

Hi PBI community,

I'm working with dates on my x axis and the default intervals is 5 days. I want to visualise activity by week, so every 7 days. Is there any way to set the intervals - see viz below:

[Icey]

Hi @Anonymous ,

Is this problem solved?

Best Regards,

Icey

[Icey · Accepted solution]

Hi @Anonymous ,

Power BI doesn't support it currently. Maybe you can try to create R visual:

library(ggplot2)
ggplot(dataset,aes(x=Day,y=Value))+geom_bar(stat="identity")+ scale_x_continuous(breaks=seq(from = 1, to = 31, by = 7))

BTW, .pbix file attached.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous ,

There is an idea for that : https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/15293673-axis-with-configurable-units-interval

Refer if these can help:

https://www.youtube.com/watch?v=n-OWNaCUU0o

https://community.powerbi.com/t5/Desktop/Can-t-control-x-axis-intervals/m-p/772383