Forum Discussion

Urgamanix's avatar
Urgamanix
New Member
1 year ago
Solved

Transposing / Pivoting and Keeping Columns Updated

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, ...
Need Help
  • Ritaf1983's avatar
    Ritaf1983
    1 year ago

    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

Urgamanix's avatar
Urgamanix
New Member
1 year ago

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

  • Ritaf1983's avatar
    Ritaf1983
    Super User
    1 year ago

    Happy to help ğŸŒº