Forum Discussion
Solved
Make rows appear in multiple filter values
Hello, I have the table "Projects" that I want to be able to filter by differents status. The problem I have is that the progression "Not Started" must appear when I select either "Not Active" and "A...
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 not really , it will be ok