Forum Discussion
Dynamic Axis on scatter chart
Hi,
I would like to make my X axis and Y axis dynamic in the scatter chart based on the years selected, for this, I have created the below measure for slicer, however I am not sure what value should I add on the X and Y axis on the scatter chart to make this slicer work.
Selected Year = SWITCH(SELECTEDVALUE('Measure (Year)'[Year Measure],"2022"),
"2022", [Average 2022 weight],
"2021", [Average 2021 weight],
"2020", [Average 2020 weight],
"2019", [Average 2019 weight],
"2018", [Average 2018 weight],
"2017", [Average 2017 weight]
)
Any help is appreciated.
1 Reply
Hi anwarbi ,
The current position can only customize the title, not yet dynamic.
If you also want this in power bi, let the power bi community to know this things and give your votes at power bi site's feedback.
https://ideas.powerbi.com/ideas/idea/?ideaid=086bbce8-1e74-4c31-a3df-59f6e5ee4b16
https://ideas.powerbi.com/ideas/idea/?ideaid=d4ca40d4-ef7e-4a48-b417-f359e93b8fb7
The problem has been solved in the post, you can refer.
Solved: Dynamic Axis Titles for Scatter chart - Microsoft Power BI Community
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
