Transposing / Pivoting and Keeping Columns Updated

[Urgamanix]

This issue is killing me, and I haven't found any clear resource to help me solve it.

I have a simple table of daily data, with an attached date:

I'm loading this data into PowerBI, and then using the data transformation tool to make the dates the columns and the headers the rows:

However, every new day, I have to go into PowerBI and add the new column to the table:

How do I get PowerPI to just automatically add every day as a new column when it exists in the database?

Regards Geoff

[Urgamanix]

Doh - I should be using a completely different visualisation! Thank you so much!

[Ritaf1983]

Happy to help 🌺

[Ritaf1983 · Accepted solution]

Hi @Urgamanix 
You should use Matrix visual like :

Date on columns
Categories on rows 
Measure on values 

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly