Slicer not affecting current month data

[Prabha45]

Hi All,
I have a card which shows current month data and I have slicer and 4 other visuals in the same page. Is it possible to make the current month card data to change based on the slicer and show current month data when nothing is selected in the slicer ?

TIA

[Gayatri_D05 · Accepted solution]

Hi @Prabha45 ,
I tried the solution on my dummy data 
When nothing is selected on the slicer it shows the max month or current month data:

When value selected it shows the respective data 

I am displaying a measure called value in the card which is created using the following logic :

Value = if(not(isfiltered('month'[Month])), CALCULATE(SUM('month'[Values]), FILTER('month','month'[Month]=MAX('month'[Month]))),CALCULATE(SUM('month'[Values])))

Hope this works on your data as well.
If your requirement is solved, please make THIS ANSWER as SOLUTION and help other users find the solution quickly. Please hit the LIKE button if this comment helps you.😊