Slicer that filters different cards based on the amount of each card

[RenanSSimao]

Hello everyone.

I've made those 2 generic tables that follows bellow to try to exemplify my issue:

Am I able to create a slicer showing all the rows from the "Responsible" table [A,B,C,D and E] that filter all the responsible in each Step?

For example:

When I filter "A" it shows how many of "A" I have in each steps, when I filter "B" it shows how many of "B" in each step, and so on...

ResponsibleTestBI].pbix

I appreciate any help.

Thank you

[amitchandak · Accepted solution]

@RenanSSimao , Unpivot the first table and then join with one column

Unpivot Data(Power Query): https://youtu.be/2HjkBtxSM0g

Or join with all the columns and use userelationship in measures

https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in...

[RenanSSimao]

Thank you!!