Forum Discussion
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 "Active" as well. I can't figure it out. Here's what I need.
A filter that shows
Not Active -->Not started
Active ---> Not Started and Ongoing
Finished ---> Over
All ---> Not Started, Ongoing and Over
Thank you
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
8 Replies
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.
Hi GuillaumeBDddd ,
Thank you parry2k , GeraldGEmerick for your inputs.We’d like to follow up regarding the recent concern. Kindly confirm whether the issue has been resolved, or if further assistance is still required. We are available to support you and are committed to helping you reach a resolution.
Best Regards,
Chaithra E.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
Hello, will it hold up when I get thousands of rows in my table?
Thank you
GuillaumeBDddd, solution is attached. It will work fine given the status table is very small, although many-to-many relationships are not recommended and should be avoided where possible.
GuillaumeBDddd not really , it will be ok
