Forum Discussion
Set custom intervals on x axis
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:
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.
3 Replies
- amitchandak
Super User
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
- Icey
Community Support
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.
- Icey
Hi Anonymous ,
Is this problem solved?
Best Regards,
Icey
