sub group in matrix visualization

[Anonymous]

Hi All

 as far my knowledge considering matrix visualization , we can't have sub groups or nested grouping ,when we insert context field in column/row  entire matrix groups for the combination of value,  is that correct..?  PBI is more adhoc self service tool or can we think this tool as enterprise for advance reporting..?

vs

[Anonymous]

HI @Anonymous,

It will be help if you provide the sample data to analysis.
By default it support to add sub group columns, for example:

Notice: you should ensure these group column has relationship, otherwise it will shows the wrong result.

Regards,

Xiaoxin Sheng

[Anonymous]

can we get this format in power bi ..?

three mesaures, quantity, unitprice, calc

description column

[Anonymous]

HI @Anonymous,

I don't think power bi can auto apply the MTD and YTD on each columns, you should write measures to instead.
If you can please share sample file for further analysis.

Regards,

Xiaoxin sheng