Forum Discussion
Repivoting Data for a Table Visual
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 , You can use matrix visual. Date as column
https://docs.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual
2 Replies
Anonymous , You can use matrix visual. Date as column
https://docs.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual
Such a simple solution! Thank you so much amitchandak