cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
zimmermanaric
Helper I
Helper I

Prior 12 Months

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!

1 ACCEPTED SOLUTION
zimmermanaric
Helper I
Helper I

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!

View solution in original post

4 REPLIES 4
zimmermanaric
Helper I
Helper I

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!

View solution in original post

@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.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




v-yuezhe-msft
Microsoft
Microsoft

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.
Capture.PNG


Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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.

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors