Time intelligence timeline

[Anonymous]

Hi,

I would like to create a graph as shown below in PBI showing the SUM of the amount in time interval from the creationDate instead of date.

Preferably also a drilldown from years to months, but I could make a slicer instead that switches between.

Regards,

Anders

[V-lianl-msft]

Hi @Anonymous ,

If you are looking to create a particular visual, table or form that calculates data a particular way, by all means, include an example of the visual or the expected results of a calculation in your post.It is even better if the expected results that you post are for the sample data that you post.

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

[amitchandak]

@Anonymous , Not very clear, You can use date table with Year, Qtr, Month columns