Matrix (or similar visual) that group similar data in a row

[Anonymous]

Hi everyone,

I'm just looking a visual that shows data like that

Getting a source like:

Obviously it's a join 1 project many tasks (title,estimated) and a join 1 task many subs (title, est)

In Data studio I can achieve it with a pivot tabble. I Power BI I tried with matrix but it put any column as a new sub-row(tree).

Is there a way with standard visual or do you know any visual that can help?

Thanks

[PaulDBrown · Accepted solution]

Choose the matrix visual and set it up as follows (I've created a measure of the SUM of "estimated" for the Values bucket):

I've also turned off the subtotals

I've attached the sample PBIX file

[Anonymous]

Unfortunately I think I came across a bug :'(

With this configuration, the horizontal scroll bar doesn't work:

On the right my fields, and highlighted last visible column with the horizontal scroll at the beginning

here, instead, the scroll is at the end but the last visible column is the same :'(

[Anonymous]

That was exactly what I was looking for! TNX!