Forum Discussion
Creating Comparison Bar Chart - Multiple Categories (using measures)
Hi Anonymous ,
According to your description, I create a sample to reproduce the problem.
Table1:
Table2:
I create two measures:
2023 Q1 = AVERAGE(Table1[Q1 2023])2023 Q2 = AVERAGE(Table2[Q2 2023])In a clustered column chart, put Category in X-axis and the two measures in Y-axis, get the result:
Is this your expected result? I attach my sample below for your reference.
Best regards,
Community Support Team_yanjiang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Actually, the Categories A-Z are actually columns in each of my two tables, with 1-10 values.
For example:
| Table 1 | |||||||||
| Country | Location | A | B | C | D | E | F | G | H |
| US | New York | 8 | 6 | 5 | 5 | 8 | 8 | 6 | 5 |
| Philippines | Manila | 7 | 4 | 6 | 4 | 7 | 7 | 4 | 6 |
| Philippines | Manila | 6 | 3 | 7 | 6 | 5 | 6 | 3 | 7 |
| US | California | 4 | 4 | 5 | 7 | 4 | 4 | 4 | 5 |
| UK | London | 5 | 8 | 2 | 3 | 3 | 5 | 8 | 2 |
| Africa | Johannesburg | 7 | 8 | 10 | 8 | 5 | 7 | 8 | 10 |
| US | New York | 8 | 9 | 2 | 9 | 8 | 8 | 9 | 2 |
| UK | Ireland | 9 | 6 | 8 | 7 | 9 | 9 | 6 | 8 |
| Australia | Sydney | 10 | 7 | 4 | 6 | 2 | 10 | 7 | 4 |
| Table 2 | |||||||||
| Country | Location | A | B | C | D | E | F | G | H |
| Latin America | Brazil | 8 | 7 | 6 | 4 | 5 | 7 | 8 | 9 |
| Latin America | Mexico | 6 | 4 | 3 | 4 | 8 | 8 | 9 | 6 |
| Australia | Melbourne | 5 | 6 | 7 | 5 | 2 | 10 | 2 | 8 |
| New Zealand | New Zealand | 5 | 4 | 6 | 7 | 3 | 8 | 9 | 7 |
| EMEA | Greece | 8 | 7 | 5 | 4 | 3 | 5 | 8 | 9 |
| EMEA | France | 8 | 7 | 6 | 4 | 5 | 7 | 8 | 9 |
| US | New York | 6 | 4 | 3 | 4 | 8 | 8 | 9 | 6 |
| EMEA | Greece | 5 | 6 | 7 | 5 | 2 | 10 | 2 | 8 |
| Australia | Sydney | 10 | 7 | 4 | 6 | 2 | 10 | 7 | 4 |
The measures I created were Q1 A, Q1 B, etc etc. then Q2 A, Q2 B. But when I'm creating a graph, it doesnt show that way. They are all lumped together.
The measures I created, if I put it in excel, will look like this: