Is it possible to display bi-weekly dates on X-axis of a chart instead of weekly dates?

[kathyyy19]

Hello Everyone!

I'm helping my team with weekly reporting (from every Thursday to the following Wednesday) since last year but the x-axis gets busier and busier as all the start of the week dates are displayed on the chart. Hence, I'm trying to make some changes to the x-axis to show only every other start of the week dates (i.e. bi-weekly week dates). 

This is how the x-axis looks like: 

This is what I would like to achieve: 

I still would like all weekly data to be shown on the columns/bars of the chart but would like to hide some week dates on the X-axis. 

Thank you in advance for your help and advice!

Kathy

[Ritaf1983]

Hi @kathyyy19 
Yes, you need to add the column date of the start week to your date table.
And use it on the x-axis.

Please refer to the linked tutorial:
https://bielite.com/blog/week-start-date-power-bi-dax/

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

[v-xiandat-msft]

Hi @kathyyy19 ,

Below is my table:

I created an index column in the power query, and then I filtered the index column for all even numbers to indicate bi-weekly

The final output is shown in the following figure:

Best Regards,

Xianda Tang

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

[kathyyy19]

Hi @v-xiandat-msft ,

Thank you very much for taking the time to show me how to achieve the outcome. However, is it possible to show the bars from the hidden weeks but hide the dates on the X-axis ONLY? For example, for 5/25/2023, I still would like the bar to be shown on the chart but this date on the x-axis is hidden.

Thank you,

Kathy

[v-xiandat-msft]

Hi @kathyyy19 ,

Sorry, I misunderstood before.

Now I give a new solution:

You'll need a date table with a column that identifies the bi-weekly period. This could be done by creating a new column in your date table using DAX that flags every other week.

colum = IF(MOD(ROUNDUP(([Date]-MIN('Table'[data])/14), 0), 2) = 0, "Show", "Hide")

Like this:

This column is then put into the filter and we show the specific values

Here's the filtered graph:

Here's the unscreened image:

Best Regards,

Xianda Tang

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

[kathyyy19]

Hi @v-xiandat-msft ,

Thank you for the new solution. However, I still think there was misunderstanding about my question. So sorry that I didn't make it clearer.  Below chart is what I would like to achieve. I would like to keep all bars on the chart but only showing every other weeks on the x-Axis. For instance, the data bar for 5/25/2023 is shown on the chart but the data is hidden on the x-axis.

Thank you!

Kathy