Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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.😊
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.😊
User | Count |
---|---|
106 | |
86 | |
81 | |
74 | |
71 |
User | Count |
---|---|
112 | |
101 | |
96 | |
74 | |
67 |