Forum Discussion
[Beginner] Slicer & Data connection
Hello, I hope you are going well!
I'm currently stuck on a problem and I'm struggling to find a solution.
I have those 2 tables and they are link by "Week num" with a many to many relationship. The thing is that when I create a formula with data from both table, only my slicer from "Week num" is working and filtering them. But I would also love my slicer about "Service" (company department) to work on this formula. But I have no idea how to do sadly.
I don't reallky know if i'm clear so if you need more information don't hesitate to ask me!!
Thank you a lot 🙂
4 Replies
- Mahesh0016
Super User
HenriDetho Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Hello yes,
So, on the left you can see my table "Service audit à réa" and on the right my main table "DATA"
The formula i'm doing is the count of OK/KO for each company department (service). I basically did my formula which was simple but when I want to filter the result of this formula. The filter slicer is only working with weeknum (because of the connection) but I would love it to work with company department slicer also.
Slicer blue OK with both but slicer red not ok because of connection with the table "Service audit à réa"
Thank you a lot, I hope those details will be helpful!
- Mahesh0016
HenriDetho , can you know me which table to want filter where table . I.e, Data table to filter Service table OR service table to Data table.
I would love DATA table to filter the service table
