Forum Discussion
Ruedi007
6 years agoFrequent Visitor
Y-Axis Slicer for different Value Fields
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 ...
- 6 years ago
@Ruedi007 , refer to
Dynamically change chart axis in Power BI
https://www.youtube.com/watch?v=6jeSIRpjv0M
v-juanli-msft
Community Support
6 years agoHi 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.