Y-Axis Slicer for different Value Fields

[Ruedi007]

Hi!

I have a BarChart with Cities on the x-Axis. What I try to accomplish is to implement a Slicer where I can choose other Fields like

- Deaths

- Inhabitants

- Car Accidents asf.

I was able to find ways to make the x-Axis dynamic but not the y-Axis. If I put the different fields just as they are into the slicer I just see the values of the Fields.

Anyone who can help me out here or can link a tutorial?

Best!

[v-juanli-msft]

Hi @Ruedi007 

Insert data to create a new table, add it to slicer,

Measure =
SWITCH (
    SELECTEDVALUE ( 'Table 2'[selection] ),
    "deaths", SUM ( 'Table'[deaths] ),
    "inhabitants", SUM ( 'Table'[inhabitants] ),
    "cars accidents", SUM ( 'Table'[cars accidents] )
)

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak · Accepted solution]

@Ruedi007 , refer to

Dynamically change chart axis in Power BI
https://www.youtube.com/watch?v=6jeSIRpjv0M