Select all items in table visual

[Anonymous]

Hello everyone,

I have a slicer that is filtering a table visual. Than on that table visual there is some filters I added manually to further filter the displayed data. Than that table visual is filtering a PieChart visual. However the PieChart is not automatically displaying the table visual data. basically I need to select all items of the table visual and than the PieChart displays the items.

So is there a way to select all items in visual with one-click instead of CTRL + Click or even better is there a way the PieChart always only displays the data of the table visual automatically?

Thanks for your replies

@Greg_Deckler @amitchandak @AlexisOlson 

[Anonymous]

Hi @Anonymous ,

To my knowledge, there is only one way to select all items in visual with CTRL +Click.

Please refer to the following document for further information.

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-multi-select

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

Best Regards

Community Support Team _ Polly

[amitchandak]

@Anonymous , As far as I know the only way is Ctrl+ Click.

You can use isfiltered in your measure to check if something is getting filtered in table, if not make the values blank

if(isfiltered(Category[Category]), [Measure], blank())

https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/

[Anonymous]

Hello @amitchandak ,

So there is no way  the PieChart always only displays the data of the table visual automatically?