Slice Data on Column Headers and Row Headers

[LinoD]

Morning Everyone;

      New to PowerBI and looking for advice. I have datat set with the first column of data being dates and headers being employee names. The corresponding data is number of sales each sales person booked on the respective day. I'm trying to use this dataset to build visualizations that let us look at an individuals performance over a scalable amount of time and also look at total performance on a given day. Here's a sample dateset:

Date	Employee 1	Employee 2	Employee 3	Employee 4	Employee 5
2020-01-01	294	103	147	62	187
2020-01-02	235	172	105	142	262
2020-01-03	61	280	224	124	58
2020-01-04	300	108	281	182	258
2020-01-05	276	292	88	70	237
2020-01-06	82	257	297	198	238
2020-01-07	291	205	257	89	184
2020-01-08	163	189	277	145	229

So how do I go about setting it up so I can see "Employee 1" performance over a selectable period of time and also the total sales on a given date across all employees?

Thanks!

[amitchandak · Accepted solution]

@LinoD , First unpivot this data.

https://radacad.com/pivot-and-unpivot-with-power-bi

Then create a date and employee dimension and table and use join them back with your table and then you can filter based on that.

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi
https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/

[LinoD]

This worked great @amitchandak , thank-you!