Switch Visualisation using dropdown list

[mo_nasser1]

Hello guys, thanks in advance

I want to switch visualization by drop-down list, i made it by buttons and bookmarks but businesses need it as a dropdown list 

[ramdas_01]

Tidy Up your Power BI report & Display Multiple Measures in a Chart using Drop Down Box & Switch DAX...

This will surely help you

[Syndicate_Admin]

Nice day.

To do this you must a new table that contains the indicators to select in the drop-down combo and make a nested switch measurement with Selectedvalue to return that value, I leave you an example, I hope it helps you.

Test =

Where Sales =

SUM(Tabla[Sales])

Where Price =

SUM(Tabla[Price])

Return

SWITCH(

TRUE(),

SELECTEDVALUE(Selected[Indicator],Sales) = "Price", Sales,

SELECTEDVALUE(Selected[Indicator],Sales) = "Sales", Sales)

Best regards.

[mo_nasser1]

Thanks for this solution, can u please send to me the power bi file 

and if I want to make this with two different charts such as a line chart and a bar chart, is can do it with this method?

[Syndicate_Admin]

Good day dear,

Disulpate the response time, I share a link with an example, I hope it is useful.

https://drive.google.com/file/d/1WK7rVPlXan2EiB7FxDYf6Gz73wixFlud/view?usp=sharing

Best regards.