how can i hide all non relevant rows in table visual

[Iculi]

Hi,

please help me. as you see here is have one table visual with  5 slicer and i want to see only those lines which are slicers related. How can i set this easily? 

Thanks

Icu

[Anonymous · Accepted solution]

Hi @Iculi ,

We can create a field parameter.

At this point the table visual object displays only the rows associated with the slicer.

If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.

Best Regards,

Neeko Tang

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

[Iculi]

Thank you for your help! 🙂

Icu

[_AAndrade]

I think what you're trying to do is hide the lines with -100% data, right?
If that's the case you need to change your 3rd measure that shows -100% to only show the value if the columns it relates to have values, that measure will be shown blank and all the rows without values will be hidden.