Make rows appear in multiple filter values

[GuillaumeBDddd]

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

[v-echaithra]

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.

[GuillaumeBDddd · Accepted solution]

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

[parry2k]

@GuillaumeBDddd not really , it will be ok

[parry2k]

@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.

[GeraldGEmerick]

@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.

[parry2k]

@GuillaumeBDddd is this what you are looking for:

[parry2k]

@GuillaumeBDddd is this what you are looking for:

[GuillaumeBDddd]

Hello, will it hold up when I get thousands of rows in my table?

Thank you