Forum Discussion
Make rows appear in multiple filter values
Hello, the solution with many to many relationship didn't work. As soon as tried with my real data (thousand of rows), the filter wasn't working. However, I found a solution with the help of Chat GPT (it needed some tweaks though).
The solution: You create a mesure that will be used as a filter in visual ( Show Row = 1) and you use the filter table values in the slicer. Here's the measure. Don't mind about the red everywhere, it is working (The fields in my real model have different names than in my example, that's why). Thank you
GuillaumeBDddd I would setup your Status table like the following and relate it to your Progression column in your other table:
| Status | Progression |
| Not Active | Not Started |
| Active | Not Started |
| Active | Ongoing |
| Finished | Over |
| All | Not Started |
| All | Ongoing |
| All | Over |
You could use Status column in a slicer and now everything should filter correclty.