visualisation help with shwoing only last 6 months columns

[JonCross]

Hi all

Very new here so forgive me is this has been covered but I have been searching for the answer and now need someone with more experience than me to point me in the right direction.  Sample data in table below.  I am trying to create visual based on the last 6 months but also only showing 6 columns in chronological order.  For example I want to show the measure data for December 2019/January2020/February2020/March2020/April2020/May2020.  Screengrab below is sort of what I want but you can see the horizontal scroll bar and it starts with January and goes on for 12 months.  Hope I am making sense.

Created at date

Resolved at date

Update at date

Year

Quarter

Month

Day

number

problem_type

Year

Quarter

Month

Day

status

Year

Quarter

Month

Day

user_id

2020

Qtr 2

May

5

12790

Other

2020

Qtr 2

May

5

Resolved

2020

Qtr 2

May

5

2019

Qtr 4

October

31

9979

SaaS

2019

Qtr 4

November

4

Resolved

2019

Qtr 4

November

4

82433

2019

Qtr 4

November

4

10006

Network/Firewall

2019

Qtr 4

November

4

Resolved

2019

Qtr 4

November

4

102878

2019

Qtr 4

November

4

10010

Workstation

2019

Qtr 4

November

4

Resolved

2019

Qtr 4

November

4

102878

2019

Qtr 4

November

6

10042

Workstation

2019

Qtr 4

November

6

Resolved

2019

Qtr 4

November

6

82434

[v-yingjl · Accepted solution]

Hi @JonCross ,

You can try this measure, put it into the table visual filter and set its value as 1

Month Control =
VAR _firstdate =
    CALCULATE ( MIN ( test[Date] ), ALLSELECTED ( test ) )
VAR _date =
    MAX ( 'test'[Date] )
VAR datediff =
    DATEDIFF ( _firstdate, _date, MONTH )
RETURN
    IF ( datediff < 6 && datediff >= 0, 1, 0 )

Here is my sample file that hopes to help you, please check and try it: visual show last 6 months value.pbix 

Best Regards,
Yingjie Li

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