How to present results per months and per Quarters

[Anonymous]

Hello,

I would like to present in a matrix,  results (ex: sales) per category, per months as well as per Quarters.  I know that it is possible to do that using a drill down but I wonder if there is a way to present all thoses results into a simple matrix as in the table below.

Thanks in advance for your help.

alepage

category		Jan	feb	mar	apr	may	jun	jul	aug	sep	oct	nov	dec
a		1	2	3	4	5	6	7	8	9	10	11	12
b		2	4	6	8	10	12	14	16	18	20	22	24
		Q1	Q2	Q3	Q4
a			6			15			24			33
b			12			30			48			66

[Nishantjain]

@Anonymous 

Why don't you add subtotals at Quarter level to show the same information in a matrix. 

I guess you are trying to create a view that your users have seen in the past that was created using something like Excel. I would suggest to avoid the use of Power BI like other tools (e.g. Excel) as may take you down the wrong path and you will spend a lot of time trying to replicate how the users are used to looking at things. I have done the same in the past and have realised it is not a good idea. Power BI is a great tool and should be used in the right way to make the most out of it. 

Thanks
Nishant

[v-piga-msft · Accepted solution]

Hi @Anonymous ,

By my tests, I'm afraid that we cannot achieve your desired matrix in Power BI currently.

You may could use the matrix like as a workaround.

Best  Regards,

Cherry