Create line chart day wise based on latest month date

[Sandeep13]

Hi All,

Create line chart daywise based on latest month. once month over it should auto change to latest month
currently manully I have to change celmonth slicer value based on latest month and year

I want when july month over my trend line start from aug based on whatever day dates is present in the month of aug

Expecting output like below but dynmically😊 

Below is sample dataset for your reference

INSERT_DT	TOTAL_COUNT
6/24/2023	200
6/25/2023	323
6/26/2023	320
6/27/2023	10
6/28/2023	30
6/29/2023	40
6/30/2023	50
7/1/2023	1
7/2/2023	3
7/3/2023	1
7/4/2023	2
7/5/2023	1
7/6/2023	2
7/7/2023	7
7/8/2023	1
7/9/2023	1
7/10/2023	1
7/11/2023	1
7/12/2023	3
7/13/2023	1
7/14/2023	149
7/15/2023	25
7/16/2023	82
7/17/2023	17
7/18/2023	253
7/19/2023	48
7/20/2023	250
7/21/2023	39
7/22/2023	252
7/23/2023	47
7/24/2023	187
7/25/2023	33
7/26/2023	178
7/27/2023	42
7/28/2023	160
7/29/2023	33
7/30/2023	87
7/31/2023	11

Thanks in adavance

Feel free incase of any doubt

Looking for your reply 

@GPower @ypower @pbiexpert @Bex @communi @amitchandak

[Anonymous · Accepted solution]

Hi @Sandeep13 ,

Please try to create a measure with below dax formula:

Measure =
VAR max_date =
    MAXX ( ALL ( 'Table' ), [INSERT_DT] )
VAR cur_date =
    SELECTEDVALUE ( 'Table'[INSERT_DT] )
VAR _diff =
    DATEDIFF ( cur_date, max_date, MONTH )
RETURN
    IF ( _diff = 0, 1 )

 Add the measure to the visual filter pane and set:

Please refer the attached .pbix file.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.