Want to change visuals, if I select all names in slicer show visual1,select single name show visual2

[venu347]

Requrement is, if I select all names in slicer show visual1,when I select single name in clicer show visual2, how to approach.
500+names in the slicer and display the visual in single page.

select single name in slicer, don't show States table , please help me, Advance thank you.

[v-xinruzhu-msft]

Hi,

Thanks for the solution zenisekd  offered, and i want to offer some more information for user to refer to.

hello @venu347 , based on your descriotion, you can consider to use bookmark to hide or display the visual first, you can refer to the following link.

Create report bookmarks in Power BI to share insights and build stories - Power BI | Microsoft Learn

then use  bookmark navigation to implement, you can refer to the following link.

Create page and bookmark navigators - Power BI | Microsoft Learn

And you can refer to the sample file i provided.

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[venu347]

Thanks for reply, but You are using shapes, but actually requirement is using slicer, when select all name dispaly visual 1 with 4 tables, and when select single name display respected selected name data with 3 tables only. both visuals in same page and same place

[v-xinruzhu-msft]

Hi @venu347 

Thanks for your quick reply, based on your description, power bi desktop  cannot hide the visual or dispaly the visual directly, if you don't want to use the bookmark , you can only hide the field in the visual instead of entire visual.

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[venu347]

Thank you for your information

[zenisekd · Accepted solution]

Hi, 

I dont think that there is such a capability atm. There is no such tool to use logic to hide/display visuals. You could use bookmarks in some cases, but you cannot connect them to a slicer.

What you could do is simply show blank value or "" in the state visual. For this simply use dax IF(COUNT(employee)>1, "", state).  So if multiple employee are selected, it wont display any value in the state visual.