Auto copy subtotal text to component

[Zuy_NA]

Dear all,

Please help me to automate this process : Create Sub_Text to key characterictis of Subtotal line as below:

Text	Value				Sub_Text	Text	Value
aakdjfakdsf	2				N	N_aakdjfakdsf	2
qoieuoc	3				N	N_qoieuoc	3
axeqe	4				N	N_axeqe	4
N Subtotal	9				N	N Subtotal	9
oiqejfasdf	2				M	M_oiqejfasdf	2
xcwd	4				M	M_xcwd	4
M Subtotal	6				M	M Subtotal	6

Thanks,

Best regards,

[v-lionel-msft]

Hi @Zuy_NA ,

Has your problem been solved?

If it is convenient, please share your solution to help more people with the same problem.

Best regards,
Lionel Chen

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

[amitchandak]

@Zuy_NA , Not very clear, But if in a matrix you can have subtotal

https://docs.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual

[Zuy_NA]

Thanks,

I have another way to do this.