Find my approach based on a union as reference below and stored in attached workbook version 10.5 located in the original thread.
1. Define an union
2. D1. Placeholder:
if [Table Name]='Orders' and [Category]='Furniture' then 'Furniture'
elseif [Table Name]='Orders1' and [Category]='Office Supplies' then 'Office Supplies'
elseif [Table Name]='Orders$' and [Category]='Technology' then 'Technology'
3. Drag D1. Placeholder & Sales to the indicated locations on Sheet Overview
PS The Measure Sales could be replaced by any other measure per Category e.g. if [tablename]='Orders' then [Profit} elseif [tablename]='Orders$' then [Discount] etc....
4. Drag the mentons objects to the indicated locations on Sheet Detail
5. Define the following action filter
Hope it helps,
example_nalmai_v10.5.twbx 2.5 MB
thanks for your reply.
Your example works really well but it's not quite what i was looking for.
I attached another example using the actual data.
I have seperate measure and i want to be able to switch between them on the Details Dashboard. For this i have to use the Parameter.
When i click on one of the measures on the Overview Dashboard, it should bring me to the Details Dashboard. With this i would Need the Parameter to Change accordingly.
example 2_2018.3.2.twbx 397.9 KB