Comparing 4 weeks of data in a grid

[SachinC]

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

[v-ljerr-msft]

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.

Regards

[SachinC]

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

[Anonymous]

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