Dynamic Legend in Stacked column chart

Hi toum 

You can use Field Parameters to achieve this. It's quite simple and easy to do. Instead of writing out instructions, you can take a look at this video on Youtube that will assist.  You can skip quite a bit of it as it's a bit lengthy!

https://www.youtube.com/watch?v=TLiqqIsk1CU

Hope this helps.

Theo

Hi toum ,

Parameter indeed enables dynamic changes in the x-axis and legend. 
Maybe you can also use bookmark to realize your effect. First, create a bookmark for the visual object when the axis is 'categories,' the legend is 'country' and then create another bookmark for the visual object when the axis is 'code,' the legend is 'state' and then You can create a button for each of the two bookmarks, and click on the button to switch between the views. As mentioned in this post:
Solved: chart type change on published bookmarks - Microsoft Fabric Community

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.