Forum Discussion
Filtering table rows based on slicer values
- 2 years ago
Hi jayn123
Is this your desired output:
If so, you can achieve by doing something like as in attached file, with the help of table transformations and then relationships. Its functionality shall depend on your actual data, I usually seldom go this way, reason is if, we follow a dimensional design, most reports are achieved in a much simpler manner. But occassionaly we may have to somehow achieve the result, then attached is just one of the way.
https://drive.google.com/file/d/1UJxotHe2vawB5i-jEYju3xJHvfrtFict/view?usp=sharing
Hope it helps.
Then add a second slicer for column B
I can't apply slicer nor filter to Column B, because I do not know what values I should filter. X and y were just examples to clarify what I'm trying to achieve. I only know what I wanna slice by Column A.