Any easy way to adjust my data to allow me to properly filter my data?

[reagornx]

Currently, my data looks like the below. I can plot it fine using a stacked bar or multi-line graph, but the issue arises if I want to make a slicer that allows me to add/remove categories. I'm assuming I need to format my dataset to be Date, Category, Value as the columns? Is there any easy way to do this?

The below is a sample of me chaning my data manually.

[Idrissshatila · Accepted solution]

HEllo @reagornx ,

this could be acheived throup unpivoting, check this out https://youtu.be/hGj2axffxHo?si=uWEBXL7Hu0C3mhaa

[reagornx]

Worked perfectly, thank you