Forum Discussion
2 dimensions lookup on the same data table, I need help please.
Hi again,
I spent a bit of time on the first part and could not figure out a way to make it work with the limitations you have (not modifying the dataset, measures only).
I would suggest that you can use a slicer on the page for Product Batch, and instead of clicking on rows in the Expired table, the user would have to find a row, check the batch number, and select it in the slicer. With the sample dataset from before:
Hope this helps!
Thank you very much Daniel,
Your explanation is very detailed and my dashboard runs smoothly,
I'm looking forward to the rest solution.
Appreciate that !
Super UserHi again,
I spent a bit of time on the first part and could not figure out a way to make it work with the limitations you have (not modifying the dataset, measures only).
I would suggest that you can use a slicer on the page for Product Batch, and instead of clicking on rows in the Expired table, the user would have to find a row, check the batch number, and select it in the slicer. With the sample dataset from before:
Hope this helps!