Hi,
I would like to create a matrix which presents the data for today on one row and on the row below presents the average data for a given type of day. I have a slicer at the top of the page so the user can change the report day.
Lets say we sell 3 different items (Item A, Item B, Item C) but on any one day, we only ever sell one item type and the price can change from day to day for the same item. Lets say on this date (10/6/2022) we are selling item B.
I want to present a table that will show the values for the given day (as selected in the slicer) and all of the other Item B sales data for the full year:
No of Sales Cost Overheads
Today 10 $10 $6.00
Average Item B 9 $11 $5.00
From the example data set below.
| Date | Item Type | Sales | Item Cost | Overheads |
| 10-Jun | B | 22 | $10.00 | $6.00 |
| 09-Jun | C | 18 | $10.00 | $5.00 |
| 08-Jun | A | 11 | $12.00 | $6.00 |
| 07-Jun | B | 21 | $11.00 | $5.00 |
| 06-Jun | C | 19 | $11.00 | $3.00 |
| 05-Jun | A | 11 | $15.00 | $7.00 |
| 04-Jun | B | 20 | $12.00 | $4.00 |
| 03-Jun | C | 20 | $9.00 | $2.00 |
| 02-Jun | A | 9 | $11.00 | $6.00 |
| 01-Jun | B | 24 | $11.00 | $5.00 |
| 31-May | C | 27 | $16.00 | $5.00 |
| 30-May | A | 13 | $12.00 | $6.00 |
Can somebody help me do this please? I am relatively new to PowerBi. I was able to do this in Tableau but I'm unsure how to do in PowerBi.
Thank you
