Forum Discussion
claudia-amm
Helper I
Helper IDynamic X Axis via Slicer
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 se...
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.
v-yuta-msft
Community Support
Community Support
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.