Dropdown selection based on another selection

[martingale2023]

I have a visualization in which i have two drop down box selection.

the second drop down selections should be based on the first selection and then query database.

e.g. my first selection is 2023 , then the second selection content should be whatever returned from below query

select distinct quarter from myTable where year = selection1Year

how to get this in power bi?

thanks

[lbendlin]

That is usually achieved through the data model.  If your slicer sources are unrelated you can use measures as visual filters.  Note: This can only ever go one way.