Conditionally change x-axis

[dats]

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

[Anonymous · Accepted solution]

Hi @dats ,

About the dynamic x-axis, you can refer to:

Dynamic change in X Axis

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.

[parry2k]

@dats 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.⚡

[dats]

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..