custom visual similar to pivot table

[Milan6687]

Hi,

I have table with Date and Amount column:

Date                      Amount

01/01/2020           100

02/02/2020            200

I have created few measure using Amount cloumn like First Amount=Amount*10  and Second Amount=Amount*20

I want to create the visual like below:

                                   01/01/2020             02/02/2020

First Amount               1000                        2000

Second Amount           2000                       4000

I tried Matix visual but its not giving what I want.

Could anyone help. Thanks in advance.

Thanks,

[amitchandak]

@Milan6687 , You can use the option show on row.

Refer - https://www.burningsuit.co.uk/blog/2019/04/7-secrets-of-the-matrix-visual/

[mahoneypat · Accepted solution]

You can use the Show On Rows feature to do that, in the format options for the matrix visual.

https://datasavvy.me/2017/08/10/you-can-now-put-values-on-rows-in-power-bi/

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

[Milan6687]

Thanku...It worked:)