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