Creating Custom Date Columns to organize aggregate data

I am new to PowerBI and would like to know if it's possible to create a table in PowerBI desktop that shows specific dates as the columns (e.g. "Today", "Yesterday", etc.) that I can use to display other aggregated data in rows. Ideally, it would look something like this and would adjust based on a date slicer:

Unfortunately I can't provide my file because I work with a lot of PII and internal ids. I have stakeholders who are used to seeing data displayed in Excel and hoping for a similar column/row format that they are familiar with. They like to export the data from the tables I use into Excel files.

Right now I have all of my date columns defined (Yesterday = Today()-1) and all of the intended rows, just no table that quite meets the criteria. Please let me know what other info I can provide to help with this problem. I know it's somewhat vague but I'm open to any suggestions on how I might achieve this or even some information as to why this isn't possible so I can explore other options. Thanks!