I have a simple Excel sheet that gets updated and changed during the day. Any ideas on how I have can get a visual that shows the comparisons of each refresh? There is not a date/time column in my data source. It is simple data...a list of cars. This changes every day and I need to see those changes. (20 down to 16 as an example.) But my 20 does not exist once the list is updated. It only shows a current list of cars at 16. Could Power Bi add a date column every time I hit refresh? I need Power Bi to remember the previous values. Ideas? Help.
Company | Cars |
Blue | 2 |
Green | 4 |
Red | 6 |
Yellow | 8 |