Please help to get required output in matrix visual

[Anonymous]

My data is as shown below

Required output,

Coulmn 0 shows total account in respective  Month-Year, Rest columns (1-5) shows only Open Acc in respective months.

Not able to get this output in power bi. 
thanks in advance.

[v-yangliu-msft · Accepted solution]

Hi  @Anonymous ,

Here are the steps you can follow：

1. Create calculated column.

Month_Year = FORMAT('Table'[Date],"mmm")&"-"&RIGHT(YEAR('Table'[Date]),2)

Month_Number = MONTH('Table'[Date])

2. Create measure.

1 =
SUMX(FILTER(ALL('Table'),'Table'[Month_Year]=MAX('Table'[Month_Year])&&'Table'[Type]=1),[Open Acc])

2 =
SUMX(FILTER(ALL('Table'),'Table'[Month_Year]=MAX('Table'[Month_Year])&&'Table'[Type]=2),[Open Acc])

3 =
SUMX(FILTER(ALL('Table'),'Table'[Month_Year]=MAX('Table'[Month_Year])&&'Table'[Type]=3),[Open Acc])

4 =
SUMX(FILTER(ALL('Table'),'Table'[Month_Year]=MAX('Table'[Month_Year])&&'Table'[Type]=4),[Open Acc])

5 =
SUMX(FILTER(ALL('Table'),'Table'[Month_Year]=MAX('Table'[Month_Year])&&'Table'[Type]=5),[Open Acc])

3. Select column [Month_Year] – Column tools – Sort by column – column [Month_Number]

4. Select Sort descending in the matrix visual object.

5. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[lbendlin]

Change your requirement. Drop the need for column 0, and enable row totals.