Forum Discussion
DAX formula
Hi Anonymous ,
If you have a clear relationship between Connection Table and Production orders. You can directly put the second field into the slicer. For example, when the two fields are in the slicer, it appears the hierarchy.
If the method like the one above doesn't work, then I guess you should create a table that contains your Test(fruit) column and Material.Material 01 column, and then act as a slicer.
You'll need to create measures as filters to implement filtering for this slicer. Or you can use this new table to create relationships with other tables for filtering.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous
Thanks for your help.
What I want to achieve is to add the Material.Material 01 to my slicer, which is from another table. So I want "Mango" to have three suboptions (or whatever the amount of different kind of materials is for that fruit) in the slicer - which all originates from another table.
Hi Anonymous ,
If you have a clear relationship between Connection Table and Production orders. You can directly put the second field into the slicer. For example, when the two fields are in the slicer, it appears the hierarchy.
If the method like the one above doesn't work, then I guess you should create a table that contains your Test(fruit) column and Material.Material 01 column, and then act as a slicer.
You'll need to create measures as filters to implement filtering for this slicer. Or you can use this new table to create relationships with other tables for filtering.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for your help. I do not have a clear relationship, so I will try to create a "bridge" table.