Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
vaishh
Regular Visitor

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 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!

pbi.png

1 ACCEPTED SOLUTION
v-xinruzhu-msft
Community Support
Community Support

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.

vxinruzhumsft_0-1722217889924.png

 

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

vxinruzhumsft_1-1722217974486.png

 

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.

View solution in original post

2 REPLIES 2
v-xinruzhu-msft
Community Support
Community Support

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.

vxinruzhumsft_0-1722217889924.png

 

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

vxinruzhumsft_1-1722217974486.png

 

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.

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)

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.