Bar Chart Issue: Duplicate Week Display Across Months

[vaishh]

I am facing an issue with the bar chart visualization . I have fully expanded the year hierarchy to show year, month, week, and day. However, I noticed that when days from two different months fall within the same week, the week is displayed twice—once under each month.

For example, if a week spans the end of one month and the beginning of the next, the same week appears under both months in the chart. This duplication is causing confusion in my data representation.

Is there a way to ensure that each week is only displayed once, regardless of the month split? Any guidance or suggestions would be greatly appreciated.

Thank you in advance for your help!

[Anonymous · Accepted solution]

Hi @vaishh 

If you want to remove the duplicate week, you cannot remove it directly based on the hierachiy, you can consider to the following solutions:

1.Revemove the month from the hierachy, then you can put the month field to the tooltip.

2.change the hierachy level, put the week to the second level, and put the month to the third level.

Best Regards!

Yolo Zhu

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

[vaishh]

I created a calculated column to adjust month :

AdjustedMonthName =

VAR CurrentDate = 'Your Table'[Date]

VAR StartOfWeek = CurrentDate - WEEKDAY(CurrentDate, 1)+1  // Get the start of the week (Monday)

VAR EndOfWeek = StartOfWeek + 6 // Get the end of the week (Sunday)

VAR StartOfWeekMonth = FORMAT(StartOfWeek,"mmm")

VAR EndOfWeekMonth = FORMAT(EndOfWeek,"mmm")

RETURN

IF(StartOfWeekMonth = EndOfWeekMonth, StartOfWeekMonth, StartOfWeekMonth)