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 ,
Sorry, I dont quite understand your requirement.
Is this your expected result? There're suboptions under 'Tomatoes' in the slicer.
All you need is to put the two fields in the same slicer, it will be the hierarchy slicer. The table visual with data from Table(2) will be filtered beacause of the relationship between the Table and the Table(2).
If you still have doubts, please provide a more detailed description, preferably some virtual sample data, and the expected results.
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.