Dynamic X Axis via Slicer

[claudia-amm]

Hi everyone.

I'm trying to make a bar chart with date as a X axis.

It displays in "days" but I want the x axis change into "weeks" when I select date range more than 30 days.

For example:

I select date range 1/1/2020 - 5/2/2020 so the x axis in bar chart show "weeks" not in "days".

Can power BI do that?

I hope you understand what I mean.

Thankyou!

[v-yuta-msft · Accepted solution]

@claudia-amm ,

You can create a new week number column using WEEKNUM(). And drag that column to X-axis. Please refer to:

https://docs.microsoft.com/en-us/dax/weeknum-function-dax

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@claudia-amm , I doubt unless you use some custom visual you can do that easily. Or you can manipulate bookmarks

https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive