Is it possible to create a matrix visualization in power-bi similar to the pic that I have attached?

Question

I would like to create a matrix visualization or custom visual that looks exactly like this:

Note that the current challenge is that the last two columns that is, "Current state weighted average score" and "Future state weighted average score" are only for domain and not for subdomain. So, that is why they are to be displayed only once(For each domain).

Is it possible to create something exactly like this in Power-BI?

Any help is appreciated. Thanks.

Answer 1

Yes, we can do that but it needs a bit things to be modified on Field formating. You can create something like this. Please check the below image which I have created something like that.

Follow the steps. In my case, I have the fields as below

1. Enable the row subtotals under the subtotals in format pane.

2. Go to field formatting and choose the "Current state weighted average score" column. In my case it is "value2" column.

3. Change only the font colour to "red" that would match the colour on the table(under the same field formatting option)

4. And enable only to values as below image.

Hope your problem should be resolved with this