Forum Discussion

SachinC's avatar
SachinC
Icon for Helper V rankHelper V
9 years ago

Comparing 4 weeks of data in a grid

hi,

I want to display 4 weeks worth of data, by week, tracking changes.

It's a simple grid by customer and number of open support tickets.

I want to use a date slicer to add more weeks if I need to.

I have done it in Excel as a pivot by week, but don't know how to do this in PowerBi.

To recap, my columns are:

  1. Org, e.g. ABC Ltd

  2. Status, e.g. Open/Closed

  3. Count of Status, e.g. 4

Thanks,

S

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Are you  looking for the Matrix visual, dragging your Count measure to Values, Status to Columns, and Date-Week and Org to Rows ?

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Hi SachinC,

     

    Have you tried using Matrix visual as Steve_Wheeler mentioned above? It should meet your requirements. If that is not the case, please post your table structures, some sample data, and your expected result for better assistance on this issue.:smileyhappy:

     

    Regards

    • SachinC's avatar
      SachinC
      Icon for Helper V rankHelper V
      9 years ago

      How do you use Matrix Visual please?  Is there a link? Thanks.