Forum Discussion
Cannot create chart from table - what is wrong with me!
How do I turn the data in this table into a stacked column chart? The answer seems obvious but for the life of me I cannot seem to make it work.
If it is your raw data first unpivot
https://radacad.com/pivot-and-unpivot-with-power-bi
If this was matrix. In stacked visual
Drag date on-axis and column on Legend.
Thank you for your response. So, I unpivoted the table (see below) but this does not appear to have given me the result I wanted. To create the chart, I put Financial Year in the Axis, Type in the Legend and Value in the Value. The value was a count only of the type for each financial year, not the actual values shown in the column. What have I done wrong?
Thanks
Steve
Ignore this entry. I have figured out what I did wrong. The Value column was not set as a Whole Number. Once this was corrected the chart worked as required.
Thanks
Steve