Zooming out on time plots

[Anonymous]

Hi!

I was curious if there's a work around to show visuals zoomed out.

For example, I'm looking at a stacked area chart where the x axis is a date hierarchy (Year, Month, Day, Hour, Minute). I want to be able to zoom out and see a large amount of data broken out by hour at once. Right now power bi only allows me to see about 48 hours at once.

I want to be able to see more of the data at once but with the same granularity. Similiar to plots in python or R.

Any insight or work arounds appreciated!

[v-xicai · Accepted solution]

Hi @Anonymous ,

It is not supported to implement your demand in Power BI currently .There is an idea about this issue, please vote it up, field-of-duration-type, to improve the Power BI.

It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

We also submitted this feedback to the product group internally, so that the product group can pay attention to this problem and speed up the issue repairing.

Please refer to the links: Display-duration-as-HH-MM-SS-on-Y-axis , Aggregating-Duration-Time ,Duration-as-Y-Axis .

To work around the issue, you can also use R visual.

library(ggplot2)
ggplot(data = dataset) + geom_bar(mapping = aes(x = Date, y = Column), stat = "identity")

Best Regards,

Amy

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