Forum Discussion

vannipart's avatar
vannipart
Frequent Visitor
8 years ago

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 would be the smartest solution for figuring that out. Ordering won’t work, neither in database side or in Powerbi. 

Picture 1 is the situation where I have both years week number, but I don't have week 44 data yet but i shows that i have that, its from 2016. And Picture 2 is where I have the unique data, but the visual look is terrible and hard to read. 

Any good ideas?

Show and Tell

6 Replies

  • miltenburger's avatar
    miltenburger
    Icon for Helper V rankHelper V
    8 years ago

    Maybe use a clustered column chart? so filter on year and week

    hope this helps you out

    • vannipart's avatar
      vannipart
      Frequent Visitor
      8 years ago

      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!

      • Eric_Zhang's avatar
        Eric_Zhang
        Icon for Microsoft Employee rankMicrosoft Employee
        8 years ago
        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!

        vannipart

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