Prior 12 Months

[zimmermanaric]

I am trying to show a column chart that has the past 12 months of sales in each bucket shown by month with the capability to drill down to the data. Any thoughts are appreciated!

[zimmermanaric · Accepted solution]

Actually, I just received the notification that the August update is out already and I believe thta the "Continuous Date" that they provided in this update is what I need. I will open another thread if not. Thanks for your help!

[kcantor]

@zimmermanaric

I accomplish this task by creating a Year-Month column on my date table to cross over the year threshold.  It is simply year-Month=[Year]&"-"&FORMAT([Month], "00"). The result is usable on the axis. It appears as 2016-01, 2016-02 etc and can cross over the year threshold with no issues.

Just in case the update did not solve this for you.

[v-yuezhe-msft]

Hi @zimmermanaric

What is your sample data? You can create a column chart in Power BI Desktop, drag Date column to Axis and drag sales to Value field. By using the drill down feature in column chart, you are able to show sales by month. There is an example for your reference, for more details, you can review the attached PBIX file.



Thanks,
Lydia Zhang

[zimmermanaric]

I am trying to show July 2015 thru August 2016 in one column view with a column for each month. I don't want to start at the year level. I am trying to show a trailing 12 month trend.

I can't quite figure out how to attach an example to these threads.