Forum Discussion
Solved
Stacked Bar Chart - multiple columns - same chart
Hi All, I'm looking to create a stacked bar chart with multiple columns from the table. I know I can create a stacked chart with a single column by putting the column name in 'Legend' but is ther...
Hello Nikhil,
1)First you need to unpivot all columns except S. No. column in power query editor.
2)Make a summary table grouping by both the columns obtained after unpivoting using count as summarization using Summarize Dax function.
3)Plot the columns of the summary table in a Stacked Column Chart. Output will look as below.
Here is the .pbix file.
Hello Nikhil,
1)First you need to unpivot all columns except S. No. column in power query editor.
2)Make a summary table grouping by both the columns obtained after unpivoting using count as summarization using Summarize Dax function.
3)Plot the columns of the summary table in a Stacked Column Chart. Output will look as below.
Here is the .pbix file.
Great thanks! Unpivot is the key. 🙂