Forum Discussion

Prabha45's avatar
Prabha45
Helper III
2 years ago
Solved

Slicer not affecting current month data

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

Need Help
Tips and Tricks
  • Gayatri_D05's avatar
    Gayatri_D05
    2 years ago

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

1 Reply

  • Gayatri_D05's avatar
    Gayatri_D05
    Resolver II
    2 years ago

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