changing visualization for different sheets on a dropdown in a single report/page

[Yashssp]

I have been unable to find a solution for achieving this in Power BI. If anyone has an answer, please respond. Thank you in advance!

How can I switch between graphs/visualizations from a dropdown list, displaying data from different sheets? The sheet names change, but all columns will be the same across sheets. I need the first dropdown list to allow selecting the sheet name, which will change the data and graph for the selected sheet. The second dropdown list will be for selecting Gender, which is a common column across all sheets. The third dropdown will be for Age, another column present in all sheets. Each sheet's graph may be different or the same. However, I need to accomplish this on a single report page in Power BI.

[Arul · Accepted solution]

@Yashssp , You can append the sheets and change the data based on the selection but changing visual is not feasible.