custom matrix

[Anonymous]

Hi

how can i create this simple matix on power bi 

Month	Amount 2020	Amount 2019	Diff Amount	Qty 2020	Qty 2019	Diff Qty
1	1270804.36	1260105.36	10699	699	596	103
2	1225113.13	1214416.13	10697	697	594	103
3	1195560.15	1184867.15	10693	693	590	103
4	886179.31	875659.31	10520	520	417	103
5	2982630.07	2971232.07	11398	1398	1295	103
5	26293.83	16285.83	10008	8	-95	103
6	1025678.34	1015053.34	10625	625	522	103
7	1521243.67	1510547.67	10696	696	593	103
8	1531554.15	1520952.15	10602	602	499	103
9	1421759.04	1411146.04	10613	613	510	103
10	1474084.58	1463377.58	10707	707	604	103
11	1138664.85	1127997.85	10667	667	564	103
12	1151715.28	1141089.28	10626	626	523	103

[Icey]

Hi @Anonymous ,

Please let us know whether this problem has been solved.

Best Regards,

Icey

[Anonymous]

hi,

its helped a bit, but its not the exact result i wanted, but i will try to work with it.

i hope in the future there will be a custom visual that you can create a custom table like in excel with all the fields you want.

thannks!

[negi007]

@Anonymous  You can achieve the output you are looking for. You will need to create seperate measures for each field like below

Amount_2020 = calculate(sum(amount), year="2020")

Amount_2019 = calculate(sum(amount), year="2019")

Diff Amount = Amount_2020 - Amount_2019

Qt_2020 = calculate(sum(qty), year="2020")

Qty_2019 = calculate(sum(qty), year="2019")

Diff Qty = Qty_2020 - Qty_2019

Once you have created above 6 measures, you can then using matrix visual and drag each measure into it. You will get the output you are looking for. Let me know if you need any further assistance.

[Anonymous]

hi,

the problem is that my date table is dynamic, according to fiscal/ calender and years, i want it to be able to change dynamically

also, i need to create in this report another table for product categories and other.

thanks

[Icey]

Hi @Anonymous ,

Please check if the matrix in this post is like what you want.

Best Regards,

Icey

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

[Pragati11]

Hi @Anonymous ,

You can definately create a matrix visual in Power BI.

But for us to help you further, you need to provide details like sample data, etc.

If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂

Thanks,

Pragati

[Anonymous]

hi 

it creates it like this:

[amitchandak]

@Anonymous , In matrix you can not column below measure as of now in matrix

There is an idea on power bi for that : https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/34743634-move-up-values-field-on-column-matrix

Workaround is to create separate measures

[Pragati11]

Hi @Anonymous ,

Please provide more information like sample data you are using to create this matrix, why you think the matrix created is wrong, etc.

If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂

Thanks,

Pragati