Forum Discussion
How can I Prevent Only One Filter For Only One Visual
Based on your description, maybe you don't need to change the DAX formula, just modify the interaction between the two visuals.
- Select the Filter
- Choose Tab "Format", click "Edit interactions"
- Make sure the Filter still seletecd, then choose none for another visual.
https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions
I tried to use ALL function like below but it didnt work.
MonthAverage = CALCULATE(AVERAGE(vSmsMessageDashboardRpt[SecDifference]), FILTER(vSmsMessageDashboardRpt, FORMAT(vSmsMessageDashboardRpt[SystemDate], "dd/mm/yyyy")>= FORMAT(DATE(YEAR(TODAY()),1,1), "dd/mm/yyyy")), ALL(vSmsMessageDashboardRpt[SystemDate]))
Based on your description, maybe you don't need to change the DAX formula, just modify the interaction between the two visuals.
- Select the Filter
- Choose Tab "Format", click "Edit interactions"
- Make sure the Filter still seletecd, then choose none for another visual.
https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions
Thanks for your help. It works 🙂