Change filter with another filter

[pedrodeantas]

Hi:

I leave the following database as example:

Region	City	Mobile	Amount
Lisboa	Lisboa	1	100
Norte	Porto	1	200
Norte	Gaia	1	500
Centro	Vieira do Minho	1	200
Centro	Leiria	1	300
Centro	Tábua	1	200

and I would like to make a Pie chart with Axis-Region and Values -Amount.

However when I make a slicer for Region filter I would like to know if there is a way to the pie chart changes the Axis Region to the City.

[negi007 · Accepted solution]

@pedrodeantas parameter field it can be achieved. attached is the pbix file