Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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.😊
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
85 | |
83 | |
66 | |
60 | |
57 |
User | Count |
---|---|
188 | |
111 | |
105 | |
78 | |
71 |