Forum Discussion
Select all items in table visual
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
3 Replies
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
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/
Hello amitchandak ,
So there is no way the PieChart always only displays the data of the table visual automatically?
