I have 2 tables: mac_familia and mac_tipo with the following structure:
I'm trying to construct a dropdown list that:
The most used example I found online is this:
but I have to find the way to brind the value of other column (mac_familia_id) based on the selected.value.
Go to Solution.
Could you please share a bit more about the formula within the Items property of your first Drop down?
I have made a test on my side, please take a try with the following workaround:
I created two Excel tables as below:
App's configuration as below:
Set the Items property of the first Drop down control (Dropdown1) to following:
mac_familia /* <-- My Excel table */
The Value proeprty of the first Drop down box within right panel set to mac_familia_desc.
Set the Items property of the second Drop down box to following:
Distinct( Filter(mac_tipo, mac_familia_id = Dropdown1.Selected.mac_familia_id), mac_tipo_desc)
If the Items property of your first Drop down box set to following:
Please set the Items property of the second Drop down to following:
Distinct( Filter( mac_tipo, mac_familia_id = LookUp(mac_familia, mac_familia_desc= Dropdown1.Selected.Value,mac_familia_id) ), mac_tipo_desc)
View solution in original post
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
The largest Power BI, Power Platform, and Data conference in New Zealand