Merging Rows in Matrix Visual

[Levoo]

Hi, I'm a PowerBI newbie so my apologies if the solution to this is simple.

I have a dataset that is basically like this:

I want to get a matrix visual that looks like this in PowerBI (with fruit and vegetable being cascadable):

But the result for me looks like this:

How can I merge the values belonging to same Type in Workers column?

[selimovd · Accepted solution]

Hey @Levoo ,

Power BI is not Excel. You cannot merge cells.

I am sorry but I don't know any way that this is possible with the default visuals at the moment. You can try to look at custom visuals or charticulator. But with default visuals I don't see how that would be possible.

I'm sorry about that. If you want you can post that as idea for the developers. Then it might appear in one of the future versions.

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards
Denis

Blog: WhatTheFact.bi
Follow me: twitter.com/DenSelimovic