Can a cluster bar chart show more than one value ?

[EaglesTony]

I have the following data:

Key                  IssueKey          IssueStatus

1                      2                      Done

1                      3                      Done

1                      4                      Design

1                      5                      Development

1                      6                      Development

1                      7                      Development

2                      88                    Backlog

2                      89                    Development

I'm trying to use a clustered bar chart and need to show the Key on the Y-Axis and the X-Axis would have the different IssueStatuses broken down within the bar, for example I would have the following(sorry for the rough drawing, but the bar itself would contain each status for each key:

1  |  Done       | Design|Development                            |

2  |  Backlog|Development|

Thanks

[abuislam]

Yes, a clustered bar chart can show multiple values by using a stacked bar format. To display different IssueStatus values for each Key, you should:

1. Place Key on the Y-Axis.
2. Add IssueStatus to the Legend.
3. Use a count or measure for the X-Axis.

This setup will break down each bar by IssueStatus, giving you a clear visual representation of the data. Just as Surah Al-Waqiah surah-al-waqiah.com  guides with structured clarity, this approach will help you effectively present your data. Hope this helps!

[EaglesTony · Accepted solution]

All, I solved it by switching from a Clustered Bar Chart to a Stacked Bar Chart.

Thanks for your help.

[v-jialongy-msft]

Hi @EaglesTony 

You can try putting the fields into the corresponding visual areas.

Result:

Best Regards,

Jayleny

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Sahir_Maharaj]

Hello @EaglesTony,

Yes, a clustered bar chart can show more than one value, and you can use it to represent different categories (in your case, IssueStatus) within a single Key.

You need to calculate the count of each IssueStatus for each Key.

CountIssues = COUNTROWS('Table')

Hope this helps!