Forum Discussion
Solved
Table visual - only show rows with values
I have two tables like so:
| Category1 | Category2 | Produce |
| Fruit | Citrus | Orange |
| Vegetable | Leafy | Spinach |
| Vegetable | Root | Turnip |
| Name | Produce | Vegetable | Fruit |
| Kevin | Orange | null | 10 |
| Kevin | Turnip | 5 | null |
| Pat | Spinach | 7 | null |
| Pat | Orange | null | 5 |
| Lisa | Turnip | 4 | null |
When I select the Produce = Spinach in a slicer, I get a table like so
| Name | Fruit | Vegetable |
| Kevin | ||
| Pat | 7 | |
| Lisa |
Is it possible to not show Kevin and Lisa in the 3rd table visual - only how names that have values in the columns, or perhaps use a different visual?
PowerBeeEye what are you using the value 7 when spinach is selected, the sum of the vegetable column? if not then you should use sum.
1 Reply
PowerBeeEye what are you using the value 7 when spinach is selected, the sum of the vegetable column? if not then you should use sum.