Forum Discussion
Stacked Bar Chart - multiple columns - same chart
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 batranikhil
If you could send sample .pbix that demonstrate what you are looking to get. It would really help providing you a quick solution.
You can send the sample .pbix file by adding it to your drive or dropbox and add the link here.
Regards
Kumail Raza
Hi Kumail - thanks for your response. I am looking to get the above stacked bar chart output as in the image with the table that I pasted above. I couldn't achieve it or havent seen it so don't have a sample so as to what output would look like in *.pbix. Hope I understood your request clearly.