Dynamic slicer selection wrt KPI & Visual

Hi chavaharika 

For your case, there are two workaround for you refer to:

1. If there no month & Tag  fields in other visuals.

You could use a separate table that only contains KPI /Visual, and use it as a slicer.

Then for each measure, you could use a IF conditional in it.

For example:

New Measure = IF(SELECTEDVALUE('separate table'[Column])="KPI", CALCULATE([Old measure],ALL(Visual's fields)) ,

IF(SELECTEDVALUE('separate table'[Column])="Visual", CALCULATE([Old measure],ALL(KPI's fields)) ))

 

2. I think the best way is use Bookmark in power bi.

You just set two status of this page, and use Edit Interaction to contorl the inteaction between the visuals,

https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive

https://docs.microsoft.com/en-us/power-bi/service-reports-visual-interactions

 

Regards,

Lin