Forum Discussion
Show two years data with only week number ?
So I have a stacked column chart, where I would like to have two years of data shown with only week number. But Power bi doesn't understand the difference, because week numbers aren’t unique. What wo...
Eric_Zhang
Microsoft Employee
Microsoft Employee
vannipart wrote:
Interesting suggestion, unfortunately this won't help me. I want to see the last year and this year data in the same chart. Thank you Eric_Zhang!
Then create column as below and the picture 2 in your original post in the only approach.
YearWeek = CONCATENATE(yourTable[Year],RIGHT(CONCATENATE(0,yourTable[weekNo]),2))
Readability, which is the most importan thing. Our data is right now like this(see picture3) But is it hard to read from it, for the end user, thats why I'm looking for a solution to show week number. But thank you for your effort Eric_Zhang.