Forum Discussion

krrish116's avatar
krrish116
Resolver II
5 years ago
Solved

Show only present Month Data before selection..

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...

 

  • 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])

1 Reply

  • 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])