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?
Helpful resources
FabCon & SQLCon – Barcelona 2026
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
Data Days 2026
Join Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.
Power BI DataViz World Championships - June 2026
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
