Power BI Table

[Anonymous]

Hi, 

I`m facing a problem when I use Table visual, I have a data that need to be filtered based on type. I applied the filter after creating a table visual, but it shows some of the data I filtered not all of it!

How to solve this issue? 

[v-xiaoyan-msft]

Hi @Anonymous ,

As we all know the effect of filters is to filter the data, when you apply a filter to your table, it will show only the data you have filtered for sure.
If you want to display all the data, clear your filters.

In case you want to implement filtering requirements while displaying all the data. You can consider creating a slicer visual that interacts with it, and your table will display all the data when you don't check any items in the slicer.

Best regards.
Community Support Team_ Caitlyn

[Anonymous]

Hi v-caitlyn-mstf, 

I know what filter do, my issue is that my data contains many types one of it called Off-Network with 1724 record, when I exported it to excel, the count of Off-Network records become 1339. That`s means there are 385 records aren`t displayed.