CODEWITHSUNDEEP
powerbi
Randy Minder
Randy Minder

Reputation: 48502

General Monthly Totals in a column oriented matrix

I have a PBI matrix that looks as follows:

enter image description here

What I would like to do is to have PBI show yearly totals at the end of each year as additional columns in the matrix. So, there would be a yearly total after the "2017-12" column and one after "2018-07". Is there a straightforward way of doing this?

Upvotes: 1

Views: 64

Answers (1)

Alexis Olson
Alexis Olson

Reputation: 40224

As Andrey suggested, you can create a hierarchy with year above month so that Power BI will subtotal at that level. It should look something like this when you drill down to the month level:

Hierarchy example

If this isn't satisfactory, then you'll have to do things much more manually.

Upvotes: 1

Related Questions