I'm not sure if it works but you could generat a list in with the resulsts and link the Dropdown to this range.

You have not mentioned which version you are using but I cannot work with your file because all the pictures are UNKNOWN for my system.

"Could it be that my approach is just wrong?
Note: I am using Office 365"

That is the version I am using. Office 365., please do let me know If I have to add some more information.

The pictures can be found here:

https://1drv.ms/f/s!AuUWSgf3FXzwhCam0WeTqpJpoZep?e=arJA3B

I apologise if too much trouble 🙁 

I'll try and see if I can help you

I've got the pictures but the file refers to a pivot table whihc is not available.

Sorry for that. No help from this side

Hello,

Thank you for the effort.

I am not sure what you mean. 

Please could you refer to which pivot table there isn't a connection?  So far it has all been placed on one sheet. And to me even if I work only through one drive, not as a downloaded file on a desktop, the dashboard is still working.

I would like really to solve this issue and perhaps I will try to recreate it again with a few pictures only. 

Tanique

Hello Hans, 

I looked at the .excel file carefully and uploaded it again. Below I posted some pictures for clarification. 

Greetings, 

Tanique 

Picture showing XlookUp formula referring to Table named "Source".

Picture showing "Slicers" referring to the table named "Products".

Picture showing Data validation / Dropdown list / referring to the table Products, first column. 

Link here: Test_Example.xlsx https://1drv.ms/x/s!AuUWSgf3FXzwhEsXtIQ1uRz6vWX9?e=ee6jeC

I took the liberty to change your set-up slightly. See attached and let me know if this works for you.

Had to remove the pictures as the file is too big otherwise. But it works as you intended if you put them back in.

Hello Riny, 

Thank you so much! I just tested it with the pictures and it works, exactly as I wished it to. 

I have noticed that one of the pivot tables "Products" is removed, and therefore the Slicer is made from the Insert menu. But perhaps that should not matter for my original file. 
Additionally, one more collum has been added to the table "Source" and then =Subtotal(3,[@Category]), which gives a result of 1. I have to study this because I am not so advanced. 

Thanks once again 

I wish you a lovely day. 

Greetings, 

Tanique 

Ah. forgot to mention that extra column. It's to enable the filter function to pick-up only visible rows fro the data table when you have made a selection with the slicer.

Hello, 

it's alright. Actually, the approach is so much simplified than what I was trying to do over a week. Sometimes simple things work the best. 🙂 

Greetings, 

Tanique

FWIW, if you don't want the additional column, you can amend the FILTER formula to do the same work:

=FILTER(Source[Name Product],BYROW(Source[Category],LAMBDA(r,SUBTOTAL(3,r)=1)))

Hello Velouriaa, 

thanks for coming to the topic with another suggestion. I will try to test also your example in more detail.

Because I am using Office 365 Beta, today both functions are not accepted and it appears an error... ;( 

Hello,

I have done many tests and tried to educate myself as much as possible. The problem is half solved.
If I don't select another item from the dropdown list ( by means not the first one ), I come to the same problem again. When choosing the Slicer, the dropdown list does change with ranged items, but the first item for a preview as a default is already not working.

Here is the picture. If the previous Slicer Radios has been selected, then moving to the next Slicer Gadgets, I have to click on the dropdown list to see the item. My whole idea was the possibility of automating exactly this very transition as a default to be the first item.

https://1drv.ms/i/s!AuUWSgf3FXzwhGyuaGCxLry5Fp4f?e=oQ3PS4