I have a table on input data formatted as per below (left of image).
I'm trying to plot the trend in value for each catergory overtime as a percentage of each days total (graph, right of image).
In excel i would first create a pivot table (middle image), with date's as rows, and the catergory pivoted to create 4 columns, and then values summed and displayed as % of row total. That would then automatically produce the desired graph as a pivot chart.
I can create a desired table in powerbi via the matrix table - but i'm then unable to then create the corresponding graph. Can anyone advise how i can create a graph in that format in powerbi?