Forum Discussion
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
- amitchandakSuper User
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])