Dynamic slicer selection wrt KPI & Visual

[chavaharika]

Hi all,

I have month & Tag as filters.If i select KPI then the filters should be interacted only with KPI's but not with visuals and if i select Visual then filters should interact only with Visuals but not with KPI's.Please help me out.

[v-lili6-msft]

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

[chavaharika]

Hi @v-lili6-msft ,

Thanks for Reply.Can i have sample report regarding DAX.

[v-lili6-msft · Accepted solution]

hi  @chavaharika 

Just use “all” functions in DAX: ALL, ALLSELECTED, ALLNOBLANKROW, ALLEXCEPT

But i would like to suggest you use my second solution

Regards,

Lin