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
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!
Solved! Go to 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.
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.
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)
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
112 | |
94 | |
91 | |
82 | |
69 |
User | Count |
---|---|
161 | |
127 | |
124 | |
108 | |
97 |