Forum Discussion

vaishh's avatar
vaishh
Regular Visitor
2 years ago
Solved

Bar Chart Issue: Duplicate Week Display Across Months

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 w...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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's avatar
    vaishh
    Regular Visitor
    2 years ago

    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)