I’m having difficulty creating a visualization with Power BI Desktop that looks like Figure 1. Additionally, I am unable to rearrange the columns and rows as I need. Is there any way to do this?
Figure 1:
We have a dataset containing product opinion across gender, age group, geography, etc. We want to pivot the opinion across different parameters, as shown in Figure 1.
However, when we use the Matrix view of Power BI and add two parameters in the columns, it creates a drill down view, as shown in Figure 2.
Figure 2:
On adding multiple fields in the column section, we get an option to move down to the next hierarchy, as shown in Figure 3.
Figure 3:
We can move down to the hierarchy, but it is not possible to show them side by side as in Figure 1. Currently, the columns and rows are automatically sorted alphabetically. Is there a way to adjust the column and row positions as desired and recreate Figure 1?