Stacked chart

[Schifo78]

Hi,

I've got data in columns that looks like this coming from a list:

Project	Jan	Feb	Mar
Project A	Complete	Complete	Due
Project B	Complete	Due	Complete
Project C	Complete	Late	Due

What sort of measure do I need to convert the nominal data into counts so that I can display in a stacked bar chart for each month of the year?

Any help is appreciated, I've got total mind blank on this!

[bsheffer]

I reccommend transpose the data to make a normalized table.  Many visuals will not take measures in an axis

https://learn.microsoft.com/en-us/power-query/transpose-table

[Schifo78]

Is that the only way, I'll have thousands of columns if I transpose the table?