Forum Discussion
Week + Month column
gsmith_eqd Try adding a sequential week number column in your table first, like this: Sequential - Microsoft Power BI Community
Thanks for the response, Greg_Deckler
If you look at my initial post, what I want is column that displays the month name and the week number and contains both month names if the week spans two months. The reason for this is that the report I'm creating displays weekly Sales numbers over the past 12 weeks on a bar chart. However, if I simply use the weeknum, month, and year as the X axis values like in the attached image, then it will display a week twice - once in January and once in February. It seems like displaying the weeks sequentially would help if I didn't want to display the month, but I do want to display the month on the visual. In this case I also think it would be confusing for the viewer to see "Week 105" instead of "Week 1" or something like that.
Maybe there's something I'm missing here, but I really just want to be able to concatenate the month names when a week spans 2 months. This would totally solve the problem.
Let me know if you have any suggestions and thanks again!