Forum Discussion
Conditionally change x-axis
Hi,
Suppose I have the following calendar table:
| Date | Year | WeekNumber | WeekNumber2 |
| 01.01.2021 | 2021 | 53 | w 53 2021 |
| .... | .... | ... | ... |
and respectively a data table containing of Date, as well through which both tables are connected.
For visuales I have a slider through which either one or a range of years can be selcted. And a line chart with ValueShare on the Y-Axis and currently on the x - axis showing "WeekNumber".
Is it possible to implement some kind of dax switch or so to conditionally change the x-axis.
For example: Whenever the year 2021 is part of the selection I want to have "WeekNumber2" as the x - axis rather than "WeekNumber"?
Would be cool to "hear" your ideas on this
dats
Hi Anonymous ,
About the dynamic x-axis, you can refer to:
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
Anonymous it is not something out of the box but check this video and you can tweak use it to meet you need.
Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
HI parry2k thanks for the idea. I will keep that in mind for further projects.
But I believe this does not work with my Year-slider which I have to/want to use..
Hi Anonymous ,
About the dynamic x-axis, you can refer to:
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
