Show only present Month Data before selection..

[krrish116]

Hi @amitchandak ,

Please help me to sort it out..

I had a table with 4 columns  

Date                    Site           Sceneario      Position

20-02-2021         CP             Referral           80

22-02-2021         OP             Gifferal            75

01-03-2021         GP             Referral            24

02-03-2021         QP            Coferral             43

We are showing data in 2 graphs

in first graph

Im showing 

Date on Axis

Scenario on Legend

Position on Values

in Second graph

Im showing

Site on Shared Axis 

Position on Column Values

Now in the Second Graph i have to show only present month data and if i select any date in first graph then it has to change based on the date selection in first graph..

Please get back to me to do this.

Thanks,

Krish...

[amitchandak · Accepted solution]

@krrish116 , is filtered should help

Assume MTD using the Date table

All measures below

measure = SUM(Table[position])

MTD = CALCULATE([measure],DATESMTD('Date'[Date]))

if(isfiltered(Date[Date]), [measure],[MTD])