I want to share an example of a case where you may want to use an XLOOKUP and filter on a hidden query tile in a dashboard. This can be useful when you have build multiple queries in a workbook that rely on each other, but you don’t need to show all of them on the dashboard.
If you have a workbook with a query that uses an XLOOKUP to reference another query, you may encounter a situation where you want to hide the XLOOKUP reference query from the dashboard. When you hide the query, the XLOOKUP will still function as expected but what if you want to use a filter?
Here you will want to un-hide your XLOOKUP query, map your filter to both queries, and then hide the XLOOKUP query again. Now you will have a dashboard query that references a hidden query via XLOOKUP, with a filter applied to both!
