Column Chart - Past 6 Months

[austinsonger]

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

[V-pazhen-msft]

@austinsonger 

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/38490

[austinsonger]

Where am I going to get into that? As you can see below, I want December and Novem to come before January.

[V-pazhen-msft · Accepted solution]

@austinsonger 

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.
  

[austinsonger]

I don't understand what you mean?

[V-pazhen-msft]

@austinsonger 

Sorry for confusion, Power bi automatically rankx month from Jan to Dec, you need to include the Year of the date in the axis. See example, you leave Year and Month in the hierarchy, click the blue make to the bottom level.

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.

[Greg_Deckler]

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.