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.
The data is sensitive, so unfortunately I cannot share a sample data.
A sample data doesn't have to sensitive. It's just representation of your actual data. You can rename the values inside the column and possibly randomized the numbers but it must represent the actual data. And from that sample data, the expected result and the reasoning behind.
It is an extra work but we don't wanna be trying to shoot at something without properly aiming at it.