Multiple value per column best way to visualise

Hi HMAnnex ,

The Table data is shown below:

Please follow these steps:
1. Use Power Query to aggregate each question into a separate table

2. Split columns into rows by separator, For more information, please refer to the following article:

Split columns by delimiter - Power Query | Microsoft Learn

3. Use the following DAX expression to create a table named ‘Question1’

Question 1 = SUMMARIZE('Table','Table'[Question 1],"count",COUNT('Table'[Question 1]))

4. Use the following DAX expression to create a measure

Top choices for question 1 = 
VAR _a = MAX('Question 1'[count])
VAR _b = CONCATENATEX(FILTER('Question 1','Question 1'[count] = _a),'Question 1'[Question 1],",")
RETURN _b

5. Use the following DAX expression to create a measure

Minimum choices for question 1 = 
VAR _a = MIN('Question 1'[count])
VAR _b = CONCATENATEX(FILTER('Question 1','Question 1'[count] = _a),'Question 1'[Question 1],",")
RETURN _b

6. Use the following DAX expression to create a column

Rank = RANKX('Question 1','Question 1'[count],,DESC,Dense)

7. Final output

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