Forum Discussion
Creating table for quadrant chart
Hi,
I have this table in PBI (here is an extract):
| Year | Answer | Total answer count | Question aggregated | Count Yes |
| 01/01/24 | Yes | 1 | Q18.20. The level of crime | 1 |
| 01/01/24 | Yes | 1 | Q18.17. Health services | 1 |
| 01/01/24 | Yes | 1 | Q17.17. Health services | 1 |
| 01/01/24 | Yes | 1 | Q17.14. Affordable decent housing | 1 |
| 01/01/24 | Yes | 1 | Q17.3. Parks and open spaces | 1 |
| 01/01/24 | Yes | 1 | Q18.21. Town centre offer | 1 |
| 01/01/24 | Yes | 1 | Q18.20. The level of crime | 1 |
| 01/01/24 | Yes | 1 | Q17.7. Cultural facilities (e.g. libraries, museums) | 1 |
| 01/01/24 | Yes | 1 | Q17.3. Parks and open spaces | 1 |
| 01/01/24 | Yes | 1 | Q17.1. Access to nature | 1 |
| 01/01/24 | Yes | 1 | Q18.20. The level of crime | 1 |
| 01/01/24 | Yes | 1 | Q18.2. Clean streets | 1 |
| 01/01/24 | Yes | 1 | Q17.20. The level of crime | 1 |
| 01/01/24 | Yes | 1 | Q17.13. Road and pavement repairs | 1 |
| 01/01/24 | Yes | 1 | Q17.2. Clean streets | 1 |
| 01/01/24 | Yes | 1 | Q18.22. Services and support for older people | 1 |
| 01/01/24 | Yes | 1 | Q18.17. Health services | 1 |
| 01/01/24 | Yes | 1 | Q18.7. Cultural facilities (e.g. libraries, museums) | 1 |
| 01/01/24 | Yes | 1 | Q17.22. Services and support for older people | 1 |
| 01/01/24 | Yes | 1 | Q17.12. Public transport | 1 |
| 01/01/24 | Yes | 1 | Q17.3. Parks and open spaces | 1 |
| 01/01/24 | Yes | 1 | Q18.21. Town centre offer | 1 |
| 01/01/24 | Yes | 1 | Q18.16. Job prospects | 1 |
I want to create a quadrant chart with the % of the answers to Q17 on the X axis and Q18 on the Y axis.
I think I need to create a new table similar to this:
| Question category | Q17 count | Q18 count |
| Health services | 17 | 24 |
| The level of crime | 15 | 12 |
| Affordable decent housing | 22 | 30 |
| Parks and open spaces | 55 | 66 |
The quadrant visualisation will end up looking something like this:
o
Is the best way to achieve this by creating a new table by using delimiters and merging do you think? Or would it be easier to do this in excel first, and then import to PBI?
