Repivoting Data for a Table Visual

[Anonymous]

Hi,

I have the following data:

Name	01/01/22	01/02/22	01/03/22
John	1	0.5	0.5
Jill	0.5	0.2	0.3

Because I wanted to use a Date calendar table as a slicer for my visuals, I unpivoted the table above. It now looks as follows, and this works quite well with most of my visuals:

Name	Date	FTE
John	01/01/22	1
John	01/02/22	0.5
John	01/03/22	0.5
Jill	01/01/22	0.5
Jill	01/02/22	0.2
Jill	01/03/22	0.3

However, I would like one of my visiuals to like my table before I unpivoted (i.e. a regular table visual with the column headers as dates). What would be the best way to do this? Currently, I have a Pivoted and Unpivoted version of data to be used for different visuals, but this seems a like a clunky solution and is causing havoc with my slicers! Any help would be much appreciated. 

[Anonymous]

 Such a simple solution! Thank you so much @amitchandak 

[amitchandak · Accepted solution]

@Anonymous , You can use matrix visual. Date as column

https://docs.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual