Can Power BI visual table/matrix display data in such matter?

[nanma94]

I want to present a data table as below - 

With first section showing monthly for 12 month and rolling total, 2nd and 3rd section showing some other aggregated calculations (measures already created) relates to each acct (account). 

Table/matrix are the closest visual but I find them not possible to create a table chart like above. Any suggestions?

Thanks a bunch!

NM

[v-jiascu-msft · Accepted solution]

Hi @nanma94,

Maybe you can use two matrix visuals. One is with columns of Months while the other only has values of measures. You can submit or vote an idea here: https://ideas.powerbi.com.

Best Regards!

Dale

[nanma94]

Thank you Dale for confirming the workaround:) I thought there would be something obvious I dont know yet:)

The limitation is I have a big list of accounts so when downloading data, the diff sections cant merge either and I have to make sure they are sorted in the same order...

Thanks again!