week + month in x-axis shown without doubles

[Anonymous]

Hello,

I have a graph (see below) with the weeks + the month and the amount of files for each of these weeks. I used for the x-axis the month + the week (which is calculated manually and added) and used the "expend next level" to get the desired results. In the settings of the x-axis I further put "concatenate labels" on "off" in order to show this data. However as can be seen in the figure, I have certains weeks that are partly covering 1 month (e.g. march) and partly another one (e.g. april). In this case, it is shown 2 times as a barplot. This is undesired for me. I just want to have one barplot per week, not multiples if there are multiples months in this week.

Someone an idea how to solve this problem?

[Anonymous]

thank you for the quick help, guys! 😊

[mahoneypat · Accepted solution]

You can add a column with either the start of the week or the end of the week (with DAX or M), take the weeknumber of that, and use that column instead in your visual.

Pat

[amitchandak]

@Anonymous , In such a case, create month year on stat of week or end of the week and use that