Stack bar chart for a training form

[umairarshad]

Hi all,

I am working on developing a PBI on training feedback. I need the 100% stack bar chart that should like below.

https://www.mediafire.com/file/tud0aa0ixfrwkqr/Original.xlsx/file

In this file column P to Y is scoring. I need chart for this data.

Thank you.

[v-sgandrathi · Accepted solution]

HI @umairarshad,

Thank you for sharing your visuals. I see that you've already unpivoted the data correctly, which is a great start. Since you're using the 100% stacked bar chart and still not getting the visual exactly as expected (like the one in your first screenshot), please ensure a few things:

Drag Rating into the Legend, Questions into the Axis, and the Value (usually named as “Percentage” or “Sum of Rating”) into Values.

Confirm that the aggregation for values is set to Don’t summarize or Sum, based on whether the values are already percentages.

Turn on Data labels under the Format pane to display the percentage values on the bars.

Adjust the color coding for each rating to visually match your desired output.

If you've tried all of this and the visual still doesn't match your requirement, could you please share a small sample of your dataset (just a few rows and columns)? That will help me assist you more precisely.

I hope my suggestions provided valuable insights. If you have any further questions, don’t hesitate to ask in a follow-up message.
If this post helped, please mark it as "Accept as Solution" so others can benefit as well.

Happy to see you here in the Microsoft Fabric Community!

[umairarshad]

Thank you a lot. It worked.

[umairarshad]

Thank you very much @v-sgandrathi.

Can you please tell where in "Values" option to put.

[Ashish_Excel]

Hi,

Share another download link.

[umairarshad]

https://docs.google.com/spreadsheets/d/1R-pM1dgvR6uL81hVvR7Mkn2QqmEipbhB/edit?usp=sharing&ouid=11729...

[v-sgandrathi]

HI @umairarshad,

I'm currently unable to access the sheet you've shared. Could you please grant access so I can take a closer look and assist you further?

Thank you.

[umairarshad]

Oh. I am soory for it. Can you please recheck?

[umairarshad]

Plz help

[umairarshad]

I did it somehow but no like as I want. Unpivot the selected columns. Please help what to do now.