Forum Discussion
Column Chart - Past 6 Months
How would I go about showing the past 6 months on a column chart (on the X-Axis).
So if I want to show the previous 6 months from April I want it to appear as the following
Nov > Dec > Jan > Feb > Mar> April
Anonymous
You should have a date column put on the x-axis. The Dec and Nov you meant should be 2019 Nov and 2019 Dec.Btw, You can just share a sample of your table, so I could help you with a definite solution.
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
6 Replies
- Greg_Deckler
Community Champion
So, this would depend on the data. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
But, you would generally create a measure that would calculate the number of months back from a chosen month and then use that as a filter on your visual. If the answer seems vague, see link above.
Anonymous
Usually you can create this measure and put the Measure in the Values of the chart, and put the Date in the Axis. I assumed you want the value of pass 6 months from today.
Measure = CALCULATE(SUM('Table'[Value]),FILTER('Table',[Date]<=TODAY()&&[Date]>=TODAY()-180))Read this post to describe your sample:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490Anonymous
You should have a date column put on the x-axis. The Dec and Nov you meant should be 2019 Nov and 2019 Dec.Btw, You can just share a sample of your table, so I could help you with a definite solution.
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
