Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
How do you use Matrix Visual please? Is there a link? Thanks.
Are you looking for the Matrix visual, dragging your Count measure to Values, Status to Columns, and Date-Week and Org to Rows ?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |