https://community.fabric.microsoft.com/t5/Developer/Dropdown-selection-based-on-another-selection/m-p/3465358#M44835 <P>That is usually achieved through the data model.&nbsp; If your slicer sources are unrelated you can use measures as visual filters.&nbsp; Note: This can only ever go one way.</P> Sat, 07 Oct 2023 23:16:26 GMT lbendlin 2023-10-07T23:16:26Z https://community.fabric.microsoft.com/t5/Developer/Dropdown-selection-based-on-another-selection/m-p/3463885#M44828 <P>I have a visualization in which i have two drop down box selection.</P><P>the second drop down selections should be based on the first selection and then query database.</P><P>e.g. my first selection is 2023 , then the second selection content should be whatever returned from below query</P><P>select distinct quarter from myTable where year = selection1Year</P><P>&nbsp;</P><P>how to get this in power bi?</P><P>thanks</P> Fri, 06 Oct 2023 13:24:46 GMT https://community.fabric.microsoft.com/t5/Developer/Dropdown-selection-based-on-another-selection/m-p/3463885#M44828 martingale2023 2023-10-06T13:24:46Z https://community.fabric.microsoft.com/t5/Developer/Dropdown-selection-based-on-another-selection/m-p/3465358#M44835 <P>That is usually achieved through the data model.&nbsp; If your slicer sources are unrelated you can use measures as visual filters.&nbsp; Note: This can only ever go one way.</P> Sat, 07 Oct 2023 23:16:26 GMT https://community.fabric.microsoft.com/t5/Developer/Dropdown-selection-based-on-another-selection/m-p/3465358#M44835 lbendlin 2023-10-07T23:16:26Z