Forum Discussion
Stacked chart
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!
2 Replies
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
Is that the only way, I'll have thousands of columns if I transpose the table?
